Archives of the TeradataForum

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

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

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>>