Timestamp-1

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
rag_TSI
Participant
Posts: 1
Joined: Sun Mar 26, 2006 11:45 pm

Timestamp-1

Post by rag_TSI »

Hi,
Need help to get a value of (CurrentTimestamp-1) in the datastage transformer.

Regards

Raghu
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Raghu, there are several builtin functions for manipulating dates in PX. Are you wishing to subtract one day or one second from your timestamp?
deepa_shenoy
Participant
Posts: 95
Joined: Thu Sep 24, 2009 12:15 am
Location: India

Post by deepa_shenoy »

Hi,

How to subtract 1 Day from timestamp?

Thanks in advance.

Deepa
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

DateFromDaysSince() applied to TimestampToDate() then rebuild the timestamp with the time component from the original timestamp.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply