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_at_crowley.com
x72546
904 727-2546

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of GovindanK Sent: Thursday, March 22, 2007 4:35 PM
To: Thomas.Mercadante_at_labor.state.ny.us; oracle-l_at_freelists.org 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  

--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 23 2007 - 07:32:45 CDT