Archives of the TeradataForum
Message Posted: Thu, 31 Jul 2008 @ 20:13:44 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|