Re: Newbie Oracle Date question

From: Mark Plant <mplant_at_uk.oracle.com>
Date: Thu, 24 Jun 1999 14:59:30 GMT
Message-ID: <3772475a.15457699@newshost.uk.oracle.com>

Oracle will not allow an invalid date to be put in a field meant to be a date - so no surprise that what you are asking does not work.

Question why you are being asked to use an invalid date. There must be another better way to solve the problem you are trying to address.

Mark.

On Tue, 22 Jun 1999 14:38:32 GMT, kwaks_at_linelnt1.light.ge.com wrote:

>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 Thu Jun 24 1999 - 09:59:30 CDT