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

Home -> Community -> Usenet -> c.d.o.server -> Dates

Dates

From: Roger Smith <rsmith22_at_fastmail.net>
Date: Tue, 21 Oct 2003 20:21:42 GMT
Message-ID: <qzglb.23859$i92.3141@clgrps13> 





I need to physicaly change a date to the first of every month ex:



12/31/2000 to 12/1/2000 and so on



select RealDate, (Changed RealDate) as NewDate
from ...





Roger
Received on Tue Oct 21 2003 - 15:21:42 CDT












Original text of this message













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