Archives of the TeradataForum

Message Posted: Tue, 21 Sep 2004 @ 13:17:54 GMT

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

Hi Srikant,

You can convert your date data to character data type using following casting.

     cast(cast(c1 as date format 'DD-MMM-YYYY') as char(11))

Hope this helps.

Sandipan

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