Page 1 of 1
Timestamp-1
Posted: Mon Mar 27, 2006 12:17 am
by rag_TSI
Hi,
Need help to get a value of (CurrentTimestamp-1) in the datastage transformer.
Regards
Raghu
Posted: Mon Mar 27, 2006 12:41 am
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?
Posted: Wed Mar 10, 2010 12:53 am
by deepa_shenoy
Hi,
How to subtract 1 Day from timestamp?
Thanks in advance.
Deepa
Posted: Wed Mar 10, 2010 2:40 am
by ray.wurlod
DateFromDaysSince() applied to TimestampToDate() then rebuild the timestamp with the time component from the original timestamp.