timezone support

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

timezone support

Gin Ng
Is there timezone support in Derby? timezone_hour and timezone_minute are
listed as SQL reserved words, but I could not find any other information
about them. I need to do an insert of timestamp in GMT. I use "CURRENT
TIMESTAMP - CURRENT TIMEZONE" in DB2 and "ALTER SESSION SET TIME_ZONE =
'-0:0'; and SYSTIMESTAMP" in Oracle.

Gin Ng