Subject Re: [firebird-support] Empty date field and value 30.12.1899
Author Aage Johansen
On Mon, 29 Mar 2004 19:12:35 +0000 (UTC), Raigo wrote:

> I am having a strange problem with date field - when a value is not
> entered, somehow into that field is inserted 30.12.1899.
> When I enter value, everything is correct.
> I am using Firebird 1.0.3. when I create the field I use
> alter table myTable add myField DATE ;
> when I look at it in Delphi's SQL Explorer I see TIMESTAMP.

Don't use the "value" if the field is Null!
If zero is returned from your 'middleware', it will show as 30.12.1899.

Aage J.