date operation

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
pramod_au
Participant
Posts: 30
Joined: Thu Feb 06, 2003 8:30 am
Location: London,UK

date operation

Post by pramod_au »

I need to do arithmetic operation using date in(mm/dd/yyyy).
i need to find difference between current system Date and date present in some filed
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Not sure how *much* help you need, so we'll start with this: Use 'iconv' to convert your dates to internal format and then do your manipulation from there. Convert dates back out using 'oconv'. The online help available from within the client is very good, so don't be afraid to poke around there. You can also look in the Manager under Routines - depending on your version there are usually 'example' or 'sdk' sections with many prewritten routines that you can steal code from.

Hope this helps,

-craig
Post Reply