Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: year 2094, parameter
you shoud use dd.mm.rr format or input in full format dd.mm.yyyy
also, update your database record
"Marcel Stör" wrote:
> hi
>
> i've come across an old pl/sql procedure that my predecessors in the it
> department of my company have written. it make inserts into a table with a
> constant date given as '01.01.94'. the oracle database interprets this as
> 01.01.2094....
> supposedly, there is a parameter that handles such situations. does anyone
> know anything about it?
> would be nice if you could help.
>
> cheers, marcel
Received on Fri Mar 23 2001 - 07:56:51 CST
![]() |
![]() |