ADDING HOURS IN TERSDATA SQL

UDA

ADDING HOURS IN TERSDATA SQL

I am querying data that resides in the US but I am in Australia. Thismeans when I query on TIMESTAMP format to get exact TIME of transaction I have to do conversion of 18 hours manually in Excel.

Is it possible to do this in Teradata?

I know of ADD_MONTHS function but is there something similar that can help here?

MANY THANKS

dbread007
1 REPLY
Enthusiast

Re: ADDING HOURS IN TERSDATA SQL

you can add the ( interval '18' hour ) to your timestamp