Re: dates

From: Yann CAUCHARD <yann.cauchard_at_online.fr>
Date: Mon, 09 Aug 1999 21:20:03 GMT
Message-ID: <01bee2ac$c5b55440$42391bd4@bsy>

There is a parameter concerning the epoch :

if your epoch parameter is less than 1950, 01 is considered as 1901. if your epoch parameter is greater than 1950, 01 is considered as 2001.

But I don't remember the name of this parameter and it's use. Sorry.

Eamonn Keating <oristech_at_tinet.ie> a écrit dans l'article <7ommtc$srr$1_at_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 - 16:20:03 CDT