Re: Use of CURRENT_DATE vs SYSDATE and DST

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Thu, 22 Mar 2007 20:35:14 UT
Message-Id: <1174595714.11044.1180895535@webmail.messagingengine.com>

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 Thu Mar 22 2007 - 15:35:14 CDT