Date Format

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
cherry
Participant
Posts: 108
Joined: Sun Jul 10, 2005 1:35 am

Date Format

Post by cherry »

Hi All,

I have field from the sequential file which is a source as dd/mm/yyyy and i need the output as dd/mon/yyyy.

Could someone help on this

Regards
Ravikumar
Maveric
Participant
Posts: 388
Joined: Tue Mar 13, 2007 1:28 am

Post by Maveric »

This question has been asked and resolved before. Do an exact search on dd/mmm/yyyy.
It is our choices that show what we truly are, far more than our abilities - J.K.Rowling
ag_ram
Premium Member
Premium Member
Posts: 524
Joined: Wed Feb 28, 2007 3:51 am

Post by ag_ram »

In Job properties there is a provision to read date in expected/input format .
You can set that to the required format and read the date , DS will take that as the date and override project default
Post Reply