Null Value Stored for Date e TimeStamp

From: Fernando Ferreira <lfernando(at)pop(dot)com(dot)br>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Null Value Stored for Date e TimeStamp
Date: 2005-03-13 00:50:15
Message-ID: 42338E47.6010502@pop.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sergey E. Koposov 2005-03-13 01:58:58 Strange postgres planner behaviour
Previous Message Tom Lane 2005-03-12 22:26:19 Re: REL8_0_STABLE and 8.0.1 release client logging difference