Marc,
What is your email address?
Peter
Search found 4 matches
- 03.03.2010, 14:26
- Forum: SQLite
- Topic: TZQuery.AsDateTime property
- Replies: 6
- Views: 1572
- 25.02.2010, 09:01
- Forum: SQLite
- Topic: TZQuery.AsDateTime property
- Replies: 6
- Views: 1572
Mark, ZQuery1.FieldByName ('maxt').AsDateTime works only if the short date format is set to yyyy-mm-dd, which doesn't make it very useful in practice. A workaround may be: var OldShortDateFormat: String; OldShortDateFormat := ShortDateFormat; ShortDateFormat := 'yyyy-mm-dd'; dt := DataMod.qEvent.Fie...
- 24.02.2010, 12:10
- Forum: SQLite
- Topic: TZQuery.AsDateTime property
- Replies: 6
- Views: 1572
Thank you W_P for your reply. You're right about the local settings. But isn't it strange that a property as AsDateTime depends on the local setting. As far as I know one of the reasons the TDateTime type is used is not to depend on the local settings. Another point is that TZTable doesn't seem to h...
- 24.02.2010, 08:35
- Forum: SQLite
- Topic: TZQuery.AsDateTime property
- Replies: 6
- Views: 1572
TZQuery.AsDateTime property
Hi, Using SQLite v3.6.22 ZeosLib v6.6.6 Delphi 6 I have created a simple SQLite table called user with one DATETIME field called t. When I try to assign a TDateTime variable dt to one of the field values using dt := ZTable1.FieldByName ('t').AsDateTime; there is no problem. Actually I want to extrac...