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
HOW TO SUBTRACT 5 HOURS FROM TIMESTAMP FIELD
Moderators: chulett, rschirm, roy
Code: Select all
TimestampFromSecondsSince(-18000,'2010-01-10 06.01.00.00')
You are the creator of your destiny - Swami Vivekananda