Re: Newbie Oracle Date question

From: Chris Nelson <ChrisNelson_at_eaton.com>
Date: Tue, 22 Jun 1999 14:03:29 -0400
Message-ID: <376FCFF1.99904557@eaton.com>

What's the problem with making your_date a nullable field, and then leaving it nulled? A date of '01/01/0000' might appear to be a real date, but it would be simpler to find rows 'where your_date IS NULL' when the need arises.

Chris

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 Tue Jun 22 1999 - 13:03:29 CDT