Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> What's the purpose of this SQL statement?

What's the purpose of this SQL statement?

From: <suisum_at_freenet.edmonton.ab.ca>
Date: 21 Jul 1998 23:11:39 GMT
Message-ID: <6p377b$vjm$1@news.sas.ab.ca>


Hi:

I don't know what is the gain of this SQL statement?

  select TO_DATE(TO_CHAR(sysdate, 'dd-MON-yy'), 'dd-MON-yy') into v_date from dual;

Why not just use the following?

 select sysdate into v_date from dual;

--
Best regards, Received on Tue Jul 21 1998 - 18:11:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US