AW: Dumb SQL question...

["Hauser, Birgitta" <Birgitta.Hauser@xxxxxxxxxxx>]

It's at least the lowest value and default value for a date in all DB2
Databases.

Birgitta

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Glenn Ericson
Gesendet: Dienstag, 4. Oktober 2005 15:29
An: Midrange Systems Technical Discussion; Midrange Systems Technical
Discussion
Betreff: Re: Dumb SQL question...


Is  this '0001-01-01' the standard"IT" version :-\ of the beginning of time?

At 09:14 AM 10/4/2005, rick baird wrote:
>I think it's '0001-01-01'
>
>On 10/4/05, Don <dr2@xxxxxxxxxxxx> wrote:
> >
> > Anyone know off hand what the default of a NOT NULL on a DATE field is
in
> > SQL?
> >
> > thanks...
> >
> > Don in DC
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/midrange-l.
> >
> >
>
>--
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/midrange-l
>or email: MIDRANGE-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.