Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

chhoda

macrumors 6502
Original poster
Oct 25, 2008
285
1
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

macrumors 68040
Sep 2, 2008
3,114
93
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.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.