trouble accessing Date field

[Eiichiro Kamiya]

I am trying sqlite, and have a trouble accessing DateTime field.
With sqlite3.exe, the field shows proper date value, but in delphi any date value becomes '1899/12/30'.
Very similar programs for Firebird have no problem of this kind.
Any advice please.

configuration : WindowsXP, Delphi2010, sqlite3, Devart sqlite DAC(tryal)

[AlexP]

hello,

To solve the problem, you need to specify correct date format, for example:

Code: Select all

  LiteConnection1.Options.DateFormat = 'dd.mm.yyyy';

[Eiichiro Kamiya]

TSQLConnection does not have Options property.
I added "DateFormat = 'dd.mm.yyyy'" to Params list, but it did not change the matter.

[AlexP]

hello,

Our VCL LiteDAC components include these options, and the options are not implemented in dbExpress driver for SQLite yet. We will review the possibility to implement this functionality in one of the next versions.

[mtbf40]

Hello,

click on the Link...
http://www.sqlite.org/datatype3.html#datetime - 1.2 Date and Time Datatype