Hi ,
I have a source file containing the date as
eg:
20080120(YYYYMMDD) and i want this to be tranformed into output target table in date format, pls help me out to do so.
Thanks,
Senthil
Date type conversion
Moderators: chulett, rschirm, roy
What "date format" do you need? There's always an IConv/OConv pair but if your incoming format is consistent then substring should be fine. For example:
To change YYYYMMDD to YYYY-MM-DD.
Code: Select all
YourField[1,4]:"-":YourField[5,2]:"-":YourField[7,2]
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
chulett wrote:What "date format" do you need? There's always an IConv/OConv pair but if your incoming format is consistent then substring should be fine. For example:
Code: Select all
YourField[1,4]:"-&quo ...[/quote] I need DD-MON-YYYY format ie (I am creating table through Datastage itself, using create table option)