Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 Mar 2003 @ 18:57:31 GMT


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


Subj:   Re: Timestamp difference
 
From:   Ganga Palakattil

Glen,

Thank you very much for your suggestion. Still I think there may be a simpler solution.

Please see the output and the minutes difference I got below. If there is NO HOUR change, I am getting the results correctly. Otherwise a value around 40 is added to it. I used the simpler expression. Please note that the TimeStamp format is in YY/MM/DDHH:MI:SS format.

SELECT  begin_time, end_time, minute(end_time - begin_time)
  FROM  logdb.process_log;

Begin_Time                      End_Time                        Minute()
03/03/1714:59:31        03/03/1715:26:10        66
03/03/1813:04:30        03/03/1813:11:27        6
03/03/1815:00:17        03/03/1815:00:21        0
03/03/1911:05:38        03/03/1911:06:22        0
03/03/1917:10:40        03/03/1917:11:16        0
03/03/1917:16:21        03/03/1917:17:04        0
03/03/2110:24:16        03/03/2110:45:19        21
03/03/2609:53:28        03/03/2610:14:22        60
03/03/2610:17:10        03/03/2610:38:53        21
03/03/2610:42:40        ?       ?

Thanks

Ganga Palakattil



     
  <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