Date Conversion

nshashi.85 · Post by **nshashi.85** » Wed Apr 23, 2008 6:52 am

I am having a flat file with date format yyyymmdd. In my target table i want to change this date format into 'yyyy-mm-dd' using transformer. Please tell me , what function should i use???

Any Help?

ray.wurlod · Post by **ray.wurlod** » Wed Apr 23, 2008 6:57 am

In server jobs there are no data types, so you can treat both as strings and simply use substrings and concatenation.

Code: Select all

InLink.TheString[1,4] : "-" : InLink.TheString[5,2] : "-" : InLink.TheString[7,2]

Or you could use Fmt() function, or a combination of Oconv() and Iconv().

Code: Select all

Fmt(InLink.TheString,"L####-##-##")

Code: Select all

Oconv(Iconv(InLink.TheString,"DYMD"),"D-YMD[4,2,2]")

devidotcom · Post by **devidotcom** » Wed Apr 23, 2008 6:58 am

use the following and try

StringtoDate(Input.column,'"%yyyy-%mm-%dd')

devidotcom · Post by **devidotcom** » Wed Apr 23, 2008 6:59 am

Oops I thought it was parallel job...

PhilHibbs · Post by **PhilHibbs** » Wed Apr 23, 2008 9:21 am

I'd do the []: style, but I'd wrap it in a Transform. I don't trust the efficiency of a generic function like Fmt or Oconv.