HOW TO SUBTRACT 5 HOURS FROM TIMESTAMP FIELD
Posted: 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
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