PDA

View Full Version : sqlite date




chhoda
Oct 27, 2009, 02:02 AM
I am given with a db schema which contains datetime field in table.

I dont see sqlite function to access.

is it to be accessed through sqlite3_column_text ?


--CH



PhoneyDeveloper
Oct 27, 2009, 10:38 AM
To sqlite everything is text.

You could use unix time and save seconds as a double.

You could see what sqlite.org has to say.