adding hours to timestamp

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
sajidkp
Participant
Posts: 114
Joined: Thu Apr 30, 2009 12:17 am
Location: New Delhi

adding hours to timestamp

Post by sajidkp »

Hi,

How can i add hours to a timestamp value in Transformer.
Regards,
Sajid KP
meet_deb85
Premium Member
Premium Member
Posts: 132
Joined: Tue Sep 04, 2007 11:38 am
Location: NOIDA

Post by meet_deb85 »

Hi,

There is no direct function to add hours.

You can use the function : -

TimestampFromSecondsSince(hour*3600, "timestamp")

It adds seconds to your timestamp. Convert your hour to second by multiplying it by 3600 and then use this in this function
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

TimestampFromSecondsSince()
Post Reply