Name
timezone — get timezone difference from a datetime
Synopsis
timezone
( |
in dt datetime , |
in ignore_timezone integer
); |
Description
The function returns timezone offset of its first argument, as an integer value in minutes. If the first argument is timezoneless and second argument is missing or zero then the returned value is NULL. If the first argument is timezoneless and second argument is nonzero then the returned value is 0.
Parameters
dt
A datetime .
ignore_timezone
Flag
Examples
Example24.420.Simple example
Get current timezone.
SQL> select timezone (now ()); callret INTEGER _______________________________________________________________________________ 120