Archives of the TeradataForum

Message Posted: Thu, 21 Dec 2006 @ 19:49:45 GMT

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

PriceJ wrote:

     SELECT
        CURRENT_TIMESTAMP(0) AS CET,
        CET AT TIME ZONE INTERVAL -'05:00' HOUR TO MINUTE AS EST;

       *** Query completed. One row found. 2 columns returned.
       *** Total elapsed time was 1 second.

                            CET                        EST
     -------------------------  -------------------------
     2006-12-21 20:42:14+01:00  2006-12-21 14:42:14-05:00

Dieter

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