subtract a day from DSJobStartTimestamp

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
just4u_sharath
Premium Member
Premium Member
Posts: 236
Joined: Sun Apr 01, 2007 7:41 am
Location: Michigan

subtract a day from DSJobStartTimestamp

Post by just4u_sharath »

Hello,
I am using DSJobStartTimestamp in transformer. I want to minus 1 day from the time the job was started and be written to the file.

thanks
Top
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

Use TimestampFromSecondsSince
You are the creator of your destiny - Swami Vivekananda
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

86400 seconds since, if I recall correctly.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
rameshkm
Participant
Posts: 24
Joined: Tue May 06, 2008 6:02 am
Location: chennai
Contact:
Contact rameshkm

Use Julianday Function

Post by rameshkm »

make that column as Julianday from date and minus 1 and again revert as date from julianday, Please correct if i am wrong
Ramesh Kumar.M
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”