Date function

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
raju4u
Participant
Posts: 56
Joined: Thu Dec 13, 2007 12:30 am

Date function

Post by raju4u »

Hi All,

My source is csc file and i am getting one coloumn is date field and want to load the date field in to the table.Can anyone tell me what function i need to use.
Date format :MM-DD-YY

Thanks in advance..
N R REDDY
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Define it as a string and then use StringToDate() with the proper format mask.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply