How to minus one day from a give timestamp data
Moderators: chulett, rschirm, roy
How to minus one day from a give timestamp data
Hi All,
i have a requirement like
i need to subtract one day from given time stamp
how to do in trnsformer, can any one help me in this regard
Thanks & Regards
Prams
i have a requirement like
i need to subtract one day from given time stamp
how to do in trnsformer, can any one help me in this regard
Thanks & Regards
Prams
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks for the input,
by using DateFromDaysSince()
i am able to get the date which is required but i need the time stamp also,
is there any option to to get timestamp also
input is timestamp and out put is also timestamp.
but now i am getting like
input is timestamp and output is date format.
thanks for the valueable input
Thanks & Regards
Prams
by using DateFromDaysSince()
i am able to get the date which is required but i need the time stamp also,
is there any option to to get timestamp also
input is timestamp and out put is also timestamp.
but now i am getting like
input is timestamp and output is date format.
thanks for the valueable input
Thanks & Regards
Prams
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You will need to decompose your input timestamp into date and time components, adjust the date component, then reassemble. You do not have to convert to string (which is what Craig suggests) - there are functions such as TimestampToDate() that you can use.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: