timezone
get timezone difference from a datetime
timezone
(in dt datetime);
Description
timezone takes a datetime and returns
an integer containing localtime - GMT in minutes.
Parameters
dt –
A datetime.
Return Values
An INTEGER containing the timezone difference.
Examples
Simple example
Get current timezone.
SQL> select timezone (now ());
callret
INTEGER
_______________________________________________________________________________
120
See Also
dayname,
dayofmonth,
dayofweek,
dayofyear,
quarter,
week,
month,
year,
hour,
minute,
second