Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie Oracle Date question
There was never a year 0 in the calender, therefore oracle should reject it
(along with any other properly configured system).
SQL> select to_date('01/01/0000','DD/MM/YYYY') from dual; select to_date('01/01/0000','DD/MM/YYYY') from dual
*
ERROR at line 1:
ORA-01841: (full) year must be between -4713 and +9999, and not be 0
Mark
kwaks_at_linelnt1.light.ge.com wrote in message
<7ko757$ae6$1_at_nnrp1.deja.com>...
>I'm a PowerBuilder programmer whose boss wants them to assign the date
>value of '01/01/0000' to an Oracle date field. PowerBuilder will accept
>this date and save it to Oracle. Oracle's date format (to_date) will
>not allow this entry via PL/SQL.
>
>My question: What problems will this, if any, cause. I'm not
>comfortable putting this date in but it is accepted.
>
>Developing in PowerBuilder 5.0.02 using Oracle 7 and Oracle 8.
>
>Thanks!
>K Kwak
>kwaks_at_linelnt1.light.ge.com
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Tue Jun 22 1999 - 10:40:25 CDT