Subject | Date format using Delphi and Firebird |
---|---|
Author | Dion |
Post date | 2005-11-12T12:34:24Z |
Hi,
What must I make sure of before inserting a record with a date field into a
Firebird 1.5 table? I get the EConvertError error 'is not a valid date',
using Delphi 7. The field is declared as a Date field in the table. I assign
the field a value as follows -
qryGen.ParamByName('workdate').Value := strtodate('2005/11/12 02:00:19
PM');
What is the best strategy concerning dates when writing an application which
connects to an FB database, especially when clients will have their own date
formats on their desktops.
Many thanks,
Dion.
[Non-text portions of this message have been removed]
What must I make sure of before inserting a record with a date field into a
Firebird 1.5 table? I get the EConvertError error 'is not a valid date',
using Delphi 7. The field is declared as a Date field in the table. I assign
the field a value as follows -
qryGen.ParamByName('workdate').Value := strtodate('2005/11/12 02:00:19
PM');
What is the best strategy concerning dates when writing an application which
connects to an FB database, especially when clients will have their own date
formats on their desktops.
Many thanks,
Dion.
[Non-text portions of this message have been removed]