Re: dates

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Mon, 09 Aug 1999 10:31:18 -0400
Message-ID: <37AEE635.2E61D53B@Unforgettable.com>

Does the value you insert contain a 4-digit year? Has someone changed the nls_date_format in your initxxx.ora to something other than the default?

Eamonn Keating wrote:

> 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 - 09:31:18 CDT