WebSphere Message Brokers
File: ak05490_
Writer: Bill Oppenheimer

Reference topic

This build: July 31, 2007 21:32:10

LOCAL_TIMEZONE function

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

Syntax

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.

Related concepts
ESQL overview
Related tasks
Developing ESQL
Related reference
Syntax diagrams: available types
ESQL datetime functions
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:32:10

ak05490_ This topic's URL is: