FromTimeZone() mvSQL database function in Jitterbit App Builder¶
Summary¶
Adjusts a date and time at the given time zone offset to UTC.
Syntax¶
FROMTIMEZONE(<datetime>, <timezoneoffset>)
Parameters¶
datetime¶
An expression that resolves to a datetime value. The datetime value is assumed to be in the given time zone offset.
timezoneoffset¶
A string in the ISO offset format ±[hh]:[mm]
.
Returns¶
Returns a datetime adjusted from the given time zone to UTC.
The datetime data type stores a timestamp without a time zone offset.
Remarks¶
The FROMTIMEZONE()
function is only supported on RDBMS data providers. The following data providers have been tested:
- DB2/LUW
- DB2/i
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- SQLite
Examples¶
Literal time zone offset¶
Given:
NOW()
evaluates to2018-08-01 17:00:00.000
The expression:
FROMTIMEZONE(NOW(), '-04:00')
Returns 2018-08-01 21:00:00.000
Client time zone offset¶
Given:
NOW()
evaluates to2018-08-01 17:00:00.000
CLIENT(TIMEZONEOFFSET)
evaluates to'-04:00'
The expression:
FROMTIMEZONE(NOW(), CLIENT(TIMEZONEOFFSET))
Returns 2018-08-01 21:00:00.000