Calculating Date -1 from Timestamp

nvuradi · Post by **nvuradi** » Sat Jun 28, 2008 9:53 pm

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

ArndW · Post by **ArndW** » Sun Jun 29, 2008 4:48 am

The TimeStampFromSecondsSince() will help you. There are 60*60*24 seconds in a day.

ray.wurlod · Post by **ray.wurlod** » Sun Jun 29, 2008 4:56 am

Moderator: please move to parallel forum

nvuradi · Post by **nvuradi** » Sun Jun 29, 2008 10:38 pm

sorry by mistake i included this as a part of the server forum.

here is what i used to get the previous day from the Timestamp

DateFromDaysSince(-1,TimestampToDate(UPDT_TS))

thank you all
naru