Date() format in server job

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
krisp321
Participant
Posts: 39
Joined: Thu Mar 04, 2010 12:39 am

Date() format in server job

Post by krisp321 »

Hi

If I give date() function in input, I see some number at the output without the date.
What is the actual date() format in server jobs

Because when I am sending a date in yyyymmdd format in server job, its converting some junk value at the out put

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

Post by chulett »

Have you read the documentation on that function? That number is the internal value of today's date. Use OConv() if you need a date string in a specific format.
-craig

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