Archives of the TeradataForum

Message Posted: Wed, 17 Aug 2005 @ 19:15:09 GMT

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

Just dump it into a string in a staging table, then SUBSTR the string and || concatenate it back together in the: yyyymmdd hh:mm:ss for TIMESTAMP or just yyyymmdd for a DATE field.

Ed Ray
Senior Data Warehouse Consultant
Teradata Government Systems

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