Search found 4 matches

by peterd
03.03.2010, 14:26
Forum: SQLite
Topic: TZQuery.AsDateTime property
Replies: 6
Views: 1572

Marc,

What is your email address?

Peter
by peterd
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...
by peterd
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...
by peterd
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...