month from date

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
sush26283
Participant
Posts: 68
Joined: Thu May 20, 2010 11:55 am

month from date

Post by sush26283 »

how do I get just the month in output column from a date in the format yyyy-mm-dd

the source column in isn TIMESTAMP and the target is in INTEGER

thanks
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Link.TimestampField[6,2]
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
sush26283
Participant
Posts: 68
Joined: Thu May 20, 2010 11:55 am

Post by sush26283 »

chulett wrote:Link.TimestampField[6,2] ...
thanks Craig..issue resolved...
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”