HOW TO SUBTRACT 5 HOURS FROM TIMESTAMP FIELD

G.K.K · Post by **G.K.K** » Wed May 12, 2010 9:14 am

HI,

I have a timestamp field which has values
'2010-01-10 06.01.00.00'
'2010-01-10 05.01.00.00' .
From the above i have to subtract 5 hours. so my o/p should look like as below:
'2010-01-10 01.01.00.00'
'2010-01-09 19.01.00.00'.
please help me in achieving this.

Thanks In Advance
kamal

anbu · Post by **anbu** » Wed May 12, 2010 9:32 am

Code: Select all

TimestampFromSecondsSince(-18000,'2010-01-10 06.01.00.00')

18000 seconds for 5 hours