Archives of the TeradataForum

Message Posted: Thu, 31 Jul 2008 @ 20:13:44 GMT

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

Assuming the fields are actually dates, use DatePart to extract the relevant parts and concatenate as needed.

For example, you can get yyyymm with

     datepart("yyyy",date()) & right("0" & datepart("m",date()),2)

mm/dd/yyyy is left as an exercise for the reader.

Dave

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