WebSphere Message Broker, Version 8.0.0.7 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS

See information about the latest product version

LOCAL_TIMEZONE function

The LOCAL_TIMEZONE datetime function returns the displacement of the local time zone from GMT.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-LOCAL_TIMEZONE----------------------------------------------><

LOCAL_TIMEZONE returns an interval value representing the local time zone displacement from GMT. As with all SQL functions that take no parameters, no parentheses are required or accepted. The value returned is an interval in hours and minutes representing the displacement of the current time zone from Greenwich Mean Time.

The sign of the interval is such that a local time can be converted to a time in GMT by subtracting the result of the LOCAL_TIMEZONE function. However, for calculations involving GMTTIMEs and GMTTIMESTAMPs, ESQL performs this transformation automatically.

Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2016Copyright IBM Corporation 1999, 2016.

        
        Last updated:
        
        Last updated: 2016-05-23 14:47:12


Reference topicReference topic | Version 8.0.0.7 | ak05490_