Oracle "date" fields return incoherent value

Denis Dresse

Delphi Developer

Tue, 04 Jun 2002 03:00:00 GMT

Oracle "date" fields return incoherent value

NT 4
Oracle 8
Delphi 4 or 5
----------------------------
How do you cope with Oracle "date" fields ? In all Delphi DBcontrols,
the dates appear as invalid value : 11/11/7110 ?
In the DBExplorer, this dates appear as correct.
It seems to be in my program. Have you a clue ?

Thanks for collaboration,

Denis

Marc Scheune

Delphi Developer

Fri, 07 Jun 2002 03:00:00 GMT

Re:Oracle "date" fields return incoherent value

On Fri, 17 Dec 1999 12:23:54 +0100, Denis Dresse

Quote

<denis.dre...@decis.be> wrote:
>NT 4
>Oracle 8
>Delphi 4 or 5
>----------------------------
>How do you cope with Oracle "date" fields ? In all Delphi DBcontrols,
>the dates appear as invalid value : 11/11/7110 ?
>In the DBExplorer, this dates appear as correct.
>It seems to be in my program. Have you a clue ?

It sounds like an incompatibility between your Oracle database's date
format settings and/or international settings, and those you use in
your Delphi app.

Marc
--------------------------------------------------------------------------
Marc Scheuner Berner Versicherungen, Dept. ISV
May the Source be With You Laupenstrasse 27
marc.scheu...@berner.ch CH-3001 BERNE, Switzerland
--------------------------------------------------------------------------

Other Threads

1. Oracle date field returns incoherent value

2. D1-D3: "SizeOf" returns different values

3. Blank fields return "|" character

4. Invalid Value for Field "Date1"

5. SQL Insert and "Date" field

6. The keys "-"/"+"/"*"

7. Oracle "Long" Fields

8. changing values to "no value"

9. ComboBox that shows "Name" and returns "Value"?

10. MasterFields "EMERGENCY" problem "No index for Fields """