Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 Mar 2003 @ 17:40:08 GMT


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


Subj:   Re: Timestamp difference
 
From:   Ganga Palakattil

John,

Here is the SQL and its output:

select begin_time,end_time, minute(end_time - begin_time)  from
logdb.process_log

Begin Time              End Time                Minute()
03/03/1813:04:30        03/03/1813:11:27        6
03/03/1917:10:40        03/03/1917:11:16        0
03/03/2110:24:16        03/03/2110:45:19        21
03/03/1911:05:38        03/03/1911:06:22        0
03/03/1917:16:21        03/03/1917:17:04        0
03/03/1815:00:17        03/03/1815:00:21        0
03/03/1714:59:31        03/03/1715:26:10        66

Please note that the timestamp format is MM/YY/DDHH:MI:SS Also note the last entry


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