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 -> dates

dates

From: Eamonn Keating <oristech_at_tinet.ie>
Date: Mon, 9 Aug 1999 14:59:03 +0100
Message-ID: <7ommtc$srr$1@scotty.tinet.ie> 





When I insert a date into an Oracle table using to_date( sysdate,
'dd-mon-yyyy') in inserts it in dd/mm/yy format. When I select it using
to_char(REV_DATE,'dd/Mon/yyyy') 1999 appears as 0099. What settings must I
change in order to use yyyy format


Many thanks


Eamonn



Received on Mon Aug 09 1999 - 08:59:03 CDT












Original text of this message













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