SQLite3Connection e os campos date - 24-09-2012 -> 2456194.5

[cavaco]

Bom dia

Estou a utilizar o SQLite3Connection1 e os campos de date ficam gravados como valor numérico.

Pedia ajuda para o que posso fazer para por ex. a data  24-09-2012 fique assim gravada na tabela e não o que e está a acontecer que é ficar  2456194.5

(não sei se é importante mas estou a usar a versão 1 em ubuntu)

Os meus agradecimentos

[Lacak2]

I answer in english.

TSQLite3Connection when storing datetime values, uses REAL format of data, which represents according to http://www.sqlite.org/datatype3.html#datetime
"Julian day numbers, the number of days since noon in Greenwich on November 24, 4714 B.C." to 24-09-2012

Try use :
select date(<your_datetime_column>) from <your_table>
and you will see correct date.

[cavaco]

Thank you for your answer!

In the program Lazarus, I can see correctly the date but as you can see by the image, when I consult the table by another way (for example sqliteManager) I  notice that in the previous program (that was made trought zeos), the date is correct and now appears in numerical form.

Thank you again for your help!

[Lacak2]

Yes it is expected. I guess, that Zeos write datetime values as string (in format YYYY-MM-DD HH:NN:SS) into SQLite so if you determine column afinity it will be TEXT.
(TSQLite3Connection writes datetime values as REAL ... it is difference)

Try do:
select typeof(Data), datetime(Data) from ApiReceitas