Date Values as 30.12.1899

[Jens Fudickar]

Hi,

without sitting at my development computer i've got a question from a customer.

Is there any known problem with the current beta release and date fields.

In the newest version of my program all date values are returned as the constant value "30.12.1899".

SQL*Net v9.2
Database 9.2 and 10g

Greetings and thanks
Jens

 

[Helene]

Could this possibly be caused by wrong handling of NULL values? We have had problems with a date component, which does not handle deletion of a date value correctly. Instead of changing the field value to NULL it is set to 0 - which causes the date to be interpreted as "30.12.1899".

In our case, this is not related to DOA, but to the delphi date component.

With regards,
Helene

 

[Jens Fudickar]

But the only thing i have changed is the doa version. All other components are unchanged.

 

[Marco Kalter]

I did a little test with the current beta, and cannot immediately find a problem with dates. Can you create a little project to reproduce this?

 

[Jens Fudickar]

I will try tomorrow.

 

[Jens Fudickar]

Done

 

[Marco Kalter]

No problem here. Can you let me know the following?

1. The results of the following query:

select * from nls_database_parameters
where parameter like 'NLS%CHARACTERSET';

2. A registry export of:

HKEY_LOCAL_MACHINE\Software\Oracle

Thanks in advance.

 

[Jens Fudickar]

Answered by Mail two hours ago