can you point me in the right direction? aka. what data type am i using to store the date in my sqlite database? is TEXT correct? how do I do a select on it? thanks.
Stephan Beal-3 wrote: > > On Mon, Jan 23, 2012 at 6:51 PM, dotolee <woo_ju...@yahoo.com> wrote: > >> >> i'm new to sqlite... and relatively new to php. just wondering what the >> best >> way is to store and compare dates. >> > > For any given 10 developers you'll likely hear 11 opinions on this topic. > IMO Unix timestamps are the most portable form out there. "Portable" > meaning, in this context, the ability to work with them (more or less > easily) in a wide variety of contexts. > > > -- > ----- stephan beal > http://wanderinghorse.net/home/stephan/ > http://gplus.to/sgbeal > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/storing-and-comparing-dates-in-sqlite-tp33189769p33189862.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
