Archives of the TeradataForum

Message Posted: Thu, 26 Dec 2002 @ 11:00:59 GMT

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

hi,

You could use the substring function to do this as shown below : to extract YYYY-MM-DD ,

sel substring( cast(current_timestamp as char(26)) from 1 for 10);

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