RE: Use of CURRENT_DATE vs SYSDATE and DST

Why did adding 1 second go to 1:59, and adding 2 seconds go to 3:00?

 

Joel Patterson 
Database Administrator 
joel.patterson@xxxxxxxxxxx 
x72546 
904  727-2546 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of GovindanK
Sent: Thursday, March 22, 2007 4:35 PM
To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Use of CURRENT_DATE vs SYSDATE and DST

 

This one is on 10g Rel2 Solaris 64 Bit
SQL> select * from v$version;
BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi

PL/SQL Release 10.2.0.2.0 - Production

CORE    10.2.0.2.0      Production

TNS for Solaris: Version 10.2.0.2.0 - Production

NLSRTL Version 10.2.0.2.0 - Production
SQL> set echo on

  1  select

  2   to_char(sysdate,'mm/dd/yyyy hh24:mi:ss')

  3  ,to_char(current_date,'mm/dd/yyyy hh24:mi:ss')

  4*  from dual

SQL> /
TO_CHAR(SYSDATE,'MM TO_CHAR(CURRENT_DAT

------------------- -------------------

03/22/2007 13:34:06 03/22/2007 13:34:07
SQL> l

  1  select

  2   to_char(sysdate,'mm/dd/yyyy hh24:mi:ss')

  3  ,to_char(current_date,'mm/dd/yyyy hh24:mi:ss')

  4*  from dual

SQL> /
TO_CHAR(SYSDATE,'MM TO_CHAR(CURRENT_DAT

------------------- -------------------

03/22/2007 13:34:24 03/22/2007 13:34:25
SQL> select to_timestamp_tz('20070311 01:59:58 US/EASTERN','YYYYMMDD
HH24:MI:SS TZR') + TO_DSINTERVAL('0 00:00:01') from dual;
11-MAR-07 01.59.59.000000000 AM US/EASTERN

SQL> select to_timestamp_tz('20070311 01:59:58 US/EASTERN','YYYYMMDD
HH24:MI:SS TZR') + TO_DSINTERVAL('0 00:00:02') from dual;
11-MAR-07 03.00.00.000000000 AM US/EASTERN

SQL>

SQL>

SQL>

SQL>

SQL>

SQL> SELECT CASE TO_NUMBER(TO_CHAR(TO_TIMESTAMP_TZ

  2               ('20070311 00:00:00 US/EASTERN','YYYYMMDD HH24:MI:SS
TZR')

  3               + TO_DSINTERVAL('0 08:00:00'),'HH24'))

  4         WHEN 8 THEN 'The patch has not been applied'

  5         WHEN 9 THEN 'The patch has been applied correctly'

  6         ELSE        'Error' end "TZTEST (RUN FROM DB HOME)"

  7    FROM DUAL;
The patch has been applied correctly
Patch  4689959 Bugs fixed:4689959
HTH
GovindanK

Other related posts: