Archives of the TeradataForum
Message Posted: Mon, 07 May 2007 @ 09:54:29 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|