Date/Time Problem in Delphi 7

[destrocaipora]

Hi everybody...

I have a problem when i try to show a date from a table in my database postgresql 7.4.2

I'm using the last version of ZEOS to Delphi 7.

The object table returns date (30/12/1899), when i show it in a grid.

The same happens in delphi 5, so i never used ZEOS to show data, only to exec updates, etc...

Is there some fix, or patch to this error? Is some configuration?

Tks everybody!

Rodrigo

[silviogs]

Hi Ricardo

Which is exactly your problem my friend.

Respectfully

Silvio Guedes

[gto]

Hello

Try with a mask.
Pick the component, double-click on it, select your field, on the object inspector put:

DisplayFormat: dd/mm/yyyy
EditMask: !99/99/9999;1;_

It may help!!

abraços

[destrocaipora]

Silvio, the problem is that Zeos show 0 value to de date fields

the grid shows 30/12/1899 because this is the value to de TDateTime 0.

I have a Time field too, that shows 00:00:00.

Gto, the Mask not works..

Tks!!

Rodrigo

[destrocaipora]

Nobody has found this problem? only me?

[pol]

Hi!
What is the real value in your table? Have you seen it with other utilities?
Have you tried ZSQLMonitor? Sometimes it helps.
Regards,
Rüdiger

[DiegoBM]

Hi,

This is a bug from Zeos components on the interface with PostgreSQL.
The matter is that Zeos components only parse Date formats like 1999-02-01 (i.e. ANSI SQL Date Format), but PosgreSQL can be configured to support the SQL style (your Date format I guess..), the German style,...

To resolve this bug you have to modify the function
"ZDbcPostgreSQLResultSet.pas" --> "GetDate" to process Date formats like ##/##/####

Regards.

[silviogs]

Hello friends

my problem not in the delphi7 and yes in the lazarus 0.9.12 and zeoslib 6.5.1 cvs and postgresql 8.1.3.

Thank you very much

Silvio Guedes