Null Value Stored for Date e TimeStamp - Mailing list pgsql-hackers

From Fernando Ferreira
Subject Null Value Stored for Date e TimeStamp
Date
Msg-id 42338E47.6010502@pop.com.br
Whole thread Raw
Responses Re: Null Value Stored for Date e TimeStamp
List 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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PERFORM] How to read query plan
Next
From: Palle Girgensohn
Date:
Subject: where is the locale set for each server instance?