Thread: Null Value Stored for Date e TimeStamp

Hi,

I would like know about the value stored for null value for fields date 
and timestamp.

Sample             SQL Server 1753/01/01              Oracle         0001/01/01             Informix       1899/01/01
Visual Foxpro  DBF   1899/12/30

I used a tool for migrate database and informed the nullvalues for date 
fields in source and destine database.

I 'm convert DBF to PostgreSQL and the values for null dates from DBF 
are stored as 1899/12/30 in PostgreSQL tables.

Thanks

Fernando Ferreira

Fernando Ferreira <lfernando@pop.com.br> writes:
> I would like know about the value stored for null value for fields date 
> and timestamp.

There isn't any; we don't store anything at all for a null.

I don't think those other DBs you mention equate a null to some
particular randomly chosen date, either.  You might be dealing with
some broken application software that uses such a thing as a way to
avoid dealing with true nulls ...
        regards, tom lane