SQLITE DATE decode
lazarus / 16-Databases

----------------------------------------------------------------------
lublinkermi · 2013-06-05 04:49

To use date field in SQLITE I find function:

Code: [Select]function FloatToSQL(D: Double): String;
begin
  Str(D, Result);
end;

In database I see date value like 41061.

My question is:
How decode number for example 41061 to TDate?

----------------------------------------------------------------------
Lacak2 · 2013-06-05 05:02

It depends what date is 0 ?
There are various epochs around.
For example Delphis TDate uses as 30.12.1899 , in unix world epoch
begins 1.1.1970 etc.
Yoy can use DateToStr(D) and you will see what you will get