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