[yunqa.de] Questions about date time manipulations in DISQLITE

From: "Edwin Yip" <mindvisualizer@xxxxxxxxx>
To: yunqa@xxxxxxxxxxxxx
Date: Sat, 5 Jul 2008 15:35:37 +0800

Hello,

I have several questions on date & time date types.

   1. I heard that the suggested data type to store a date time value is
   Julian day, is the corresponding field type REAL?
   2. Is the date type DATETIME in the CREATE TABLE sql statement same as
   REAL?
   3. So when reading a Julianday with TDisqlite3Statement, is the right
   method Column_Double?
   4. I suggest Ralf to add a DEMO for handling datetiem with DISQLITE :)


Thanks.

Best Regards,

Edwin Yip

[yunqa.de] Questions about date time manipulations in DISQLITE

Other related posts: