Re: Date columns

From: Steve Bell <swayne.bell_at_sympatico.ca>
Date: Wed, 11 Apr 2001 12:12:21 GMT
Message-ID: <3AD447F6.9E0DCFA6@sympatico.ca>

I can second Mark's response,

I tried a zero with single quotes and got

ORA-01847: day of month must be between 1 and last day of month

The NVL function doesn't work either - i.e. entering a null in the date field then selecting NVL(datefield, '0') - same error.

So I'll just echo Mark's suggestion...fill us in with a little more detailed explanation of your problem and we'll give it a shot .

Steve

Mark Townsend wrote:

> in article 3AD3E8C6.11B45DC6_at_thanks.com, Trevor at nospam_at_thanks.com wrote
> on 4/10/01 10:16 PM:
>
> > Hi
> >
> > Is it possible to store a non-null but zero date in an
> > Oracle table?
>
> Crikey dick - a Trev from Down Under :-)
>
> Not really - there is no concept of a zero date. Perhaps if you explain the
> problem you have that a zero date would solve you might get some ideas.
Received on Wed Apr 11 2001 - 07:12:21 CDT