Dates in SQLite3
lazarus / 16-Databases

----------------------------------------------------------------------
noealejandro · 2011-08-20 00:15

I record a date in a date field:

Code: [Select]mySQL.FieldByName('myDate').AsDateTime :=
myDateEdit.Date)
Then if I use a GUI database manager to do a SELECT to the table, I
get an integer number (e. g., 40770). My DBGrid don't show that
number, but a valid date (15/08/2011)   But, how can I compare that
number with a date? How can I get a number from a date?

Thanks in advance.

----------------------------------------------------------------------
LuizAmérico · 2011-08-20 01:21

http://sqlite4fpc.yolasite.com/faq.php

----------------------------------------------------------------------
noealejandro · 2011-08-20 17:23

Great! Thanks a lot