hi i have a requirement where in i have to calculate the previous day from the timestamp from the source.
I have tried using timestamptodate(TS) - 1, then realised that it is not possible.
i have tried using SecondsSinceFromTimestamp, but to no avail.
can anyone help me with the right approach.
thanks,
Naru
Calculating Date -1 from Timestamp
Moderators: chulett, rschirm, roy
The TimeStampFromSecondsSince() will help you. There are 60*60*24 seconds in a day.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: