How to check the timezone of oracle pl/sql developer

sql oracle plsql plsqldeveloper
sith picture sith · May 30, 2016 · Viewed 38.4k times · Source

Where do I check the timezone of oracle pl/sql developer.Can someone help please

Answer

mathguy picture mathguy · May 30, 2016

I just ran select systimestamp from dual; in SQL developer on my machine, it replied with 30-MAY-16 12.49.28.279000000 PM -05:00. The -05:00 shows the timezone offset (5 hours behind UTC, essentially 5 hours behind GMT with no daylight savings time adjustments made to GMT). This shows the database server time zone.

Then I ran select current_timestamp from dual; and I got: 30-MAY-16 12.54.17.762000000 PM AMERICA/CHICAGO which in fact is the same timezone (but in different format - it depends on the settings I have). I get the same result because my "server" is on my personal laptop, which is also the "client". In the general case, the timezone component from this query will be the "local" or "client" or "session" timezone, while the first query (with systimestamp) gives the "server" or "database" timezone.

Related questions

Oracle Convert Seconds to Hours:Minutes:Seconds

I have a requirement to display user available time in Hours:Minutes:Seconds format from a given total number of seconds value. Appreciate if you know a ORACLE function to do the same. I'm using Oracle. Thank you for your …

Read More
How to create cursor inside procedure body in plsql

I want create cursor inside procedure body dynamically also i have to use for loop instead of below code. i did the dynamic cursor but i cannot use the for loop. PROCEDURE myprocedure AS LV_TEST_CUR SYS_REFCURSOR; LV_…

Read More
Timezone conversion in PLSQL

I need to convert the sysdate and time to a particular timezone like EST. I can't assume my current time zone. How to convert this in plsql? Please help me.

Read More