little tips and tricks, which i stumbled upon randomly

Monday, January 20, 2014

How to change time zone in sql

SELECT CAST ((FROM_TZ (CAST (SYSDATE AS TIMESTAMP), 'GMT') AT LOCAL) AS DATE) "Local Time" FROM DUAL

0 comments:

Post a Comment