Archives of the TeradataForum

Message Posted: Wed, 09 Jan 2008 @ 16:31:48 GMT

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

<-- Anonymously Posted: Wed, 9 Jan 2008 10:30 -->

Syntax:

     select cast(cast(current_date as format 'yymm') as char(4))

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