Subtract hours from timestamp

[wanyunyang]

Hi guys,

How to subtract 5 hours from a timestamp filed named DateAndTime? Something like:

Timestamp(DateAndTime-05:00:00,'MM/DD/YYYY hh:mm:ss')

Thanks in advance!

[rwunderlich · Accepted solution]

DateAndTime - MakeTime(5)

-Rob

[vishsaggi · Accepted solution]

Hi Rob,
May be we need to use Timestamp around your expr to get the datetime.

Timestamp(DateAndTime - MakeTime(5))