Archives of the TeradataForum

Message Posted: Fri, 30 Jun 2006 @ 08:44:20 GMT

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

You can normalize timestamp data in Teradata using a CAST. See below:

1. Table column should be: TRAN_TS TIMESTAMP(6) WITH TIME ZONE NOT NULL,

2. Selected as: CAST(TRAN_TS AS TIMESTAMP(6)) /* rolls time zone into timestamp */

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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