Archives of the TeradataForum

Message Posted: Thu, 26 Dec 2002 @ 21:44:41 GMT

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

In V2R5 you can apply your own format to time and timestamp. Otherwise, check the default formatting and adjust accordingly. For example, on V2R4.1.3 system

SELECT format(current_timestamp);

Format(Current_Timestamp())
yyyy-mm-dd hh:mm:ss.s(6)-hh:mm

So the following would do the trick:

SELECT CAST ( ( SUBSTRING ( ( CAST ( Current_Timestamp AS CHAR(32) ) )
FROM 1 FOR 26 ) ) AS CHAR(26) );

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