Archives of the TeradataForum

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

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

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