Archives of the TeradataForum

Message Posted: Mon, 16 Sep 2002 @ 11:43:14 GMT

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

If you need to convert a DB2 Timestamp to Teradata here's some SQL we use in an DB2 UNLOAD Utility from CA that worked great:

,CHAR(DATE(DB2_TIMESTMP)) || ' ' ||
SUBSTR(HEX(DB2_TIMESTMP),9 ,2) || ':' ||
SUBSTR(HEX(DB2_TIMESTMP),11,2) || ':' ||
SUBSTR(HEX(DB2_TIMESTMP),13,2) || '.' ||
SUBSTR(HEX(DB2_TIMESTMP),15,6)

Anthony S. Howe
Teradata/DB2 Database Administrator
Highmark Blue Cross/Blue Shield

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