Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 17 Feb 2011 @ 15:40:43 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


Subj:   Invalid timestamp
 
From:   JAMES PARK

Dear users,

I ran below SQL using SQL Assistant and got an error saying 'invalid timestamp'. I don't know what causes the error. I'd like to generate the report by month from dbc.qrylog table. What is the best way to do it?

Thank you in advance.


     Sel  *
     from  dbc.qrylog
     where CollectTimeStamp  between '06/01/2010 10:10:01' and '06/31/2010 11:00:59'
     sample 5;


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016