Archives of the TeradataForum

Message Posted: Wed, 17 Aug 2005 @ 19:29:55 GMT

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

     select '01jan2000' (date,format'DDMMMYYYY')

should work

Ulrich

--
Ulrich Arndt

www.data2knowledge.de

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