CODEWITHSUNDEEP
oracle-databasedstto-char
user503647
user503647

Reputation: 41

oracle to_char daylight savings

In below, why isn't Daylight savings included in to_char()? How can i get the time with daylight savings?

SELECT systimestamp AT TIME ZONE 'Australia/Adelaide' from dual;
SELECT TO_CHAR(systimestamp AT TIME ZONE 'Australia/Adelaide' ,'yyyy-MM-dd HH:MI:SS AM') from dual;

returns

16-OCT-13 07.19.01.165681000 PM AUSTRALIA/ADELAIDE
2013-10-16 06:19:01 PM

Upvotes: 2

Views: 1732

Answers (2)

user503647
user503647

Reputation: 41

The issue was because of outdated timezones files in oracle server. Adelaide timezones were updated around 2008 or 2007. once timezone files were updated issue got resolved.

Upvotes: 1

Yván Ecarri
Yván Ecarri

Reputation: 1738

select to_char( systimestamp at time zone 'AUSTRALIA/ADELAIDE', 
'HH24:MI:SS TZR TZD' ) from dual

http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements004.htm#i34510

Upvotes: 2

Related Questions