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
little tips and tricks, which i stumbled upon randomly
SELECT CAST ((FROM_TZ (CAST (SYSDATE AS TIMESTAMP), 'GMT') AT LOCAL) AS DATE) "Local Time" FROM DUAL
0 comments:
Post a Comment