Archives of the TeradataForum

Message Posted: Mon, 07 May 2007 @ 09:54:29 GMT

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

Hi Steve,

Do you want only period '.' delimiter for time part ?

I am not very sure but period ('.' or 'D') may be reserved as it is a Radix seperator which separates the seconds from miliseconds in TIME portion of Timestamp.

If other delimiters are ok to you then you may try similar to this :

     select TS_COLUMN(Format 'YYYY-MM-DD-HH/MI/SSDS(6)') from
     WM_AD_HOC.TABLE1

Regards,

Rajesh Jain

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