On Sep 13, 2011, at 8:18 AM, Akash Agrawal wrote:
> I have table in which i have column of Date contain both *date and
> time*
Well, considering that SQLite doesn't have any "date and time" data type it's
hard to tell...
To quote the fine manual:
SQLite does not have a storage class set aside for storing dates and/or times.
Instead, the built-in Date And Time Functions of SQLite are capable of storing
dates and times as TEXT, REAL, or INTEGER values:
• TEXT as ISO8601 strings ("YYYY-MM-DD HH:MM:SS.SSS").
• REAL as Julian day numbers, the number of days since noon in
Greenwich on November 24, 4714 B.C. according to the proleptic Gregorian
calendar.
• INTEGER as Unix Time, the number of seconds since 1970-01-01 00:00:00
UTC.
Applications can chose to store dates and times in any of these formats and
freely convert between formats using the built-in date and time functions.
http://www.sqlite.org/datatype3.html
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
