Archives of the TeradataForum

Message Posted: Wed, 12 Jan 2005 @ 15:52:04 GMT

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

Hi Geoffrey,

there's no need to do that complex calculation ;-)

     select
       (cast(current_timestamp as date) - date '1970-01-01') * 86400 +
       + (extract(hour from current_timestamp) * 3600)
       + (extract(minute from current_timestamp) * 60)
       + cast(extract(second from current_timestamp) as integer)
     ;

Dieter

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