Archives of the TeradataForum

Message Posted: Tue, 04 May 2010 @ 20:19:10 GMT

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

There's no need for the UDF because a date can be cast to a timestamp and the time is set to 0

     select cast(cast('20001015    ' as date format'yyyymmdd') as timestamp(6));

returns 2000-10-15 00:00:00.000000,

Thanks,

Bruce

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