Re: [sqlite] storing and comparing dates in sqlite

2012-01-24 Thread Nick Shaw
-users@sqlite.org Subject: Re: [sqlite] storing and comparing dates in sqlite 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

[sqlite] storing and comparing dates in sqlite

2012-01-23 Thread dotolee
, updated from myhistory group by field1 order by updated desc -- View this message in context: http://old.nabble.com/storing-and-comparing-dates-in-sqlite-tp33189769p33189769.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users

Re: [sqlite] storing and comparing dates in sqlite

2012-01-23 Thread Stephan Beal
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

Re: [sqlite] storing and comparing dates in sqlite

2012-01-23 Thread dotolee
-- 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

Re: [sqlite] storing and comparing dates in sqlite

2012-01-23 Thread Stephan Beal
On Mon, Jan 23, 2012 at 7:01 PM, dotolee woo_ju...@yahoo.com wrote: 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? http://en.wikipedia.org/wiki/Unix_time -- - stephan beal

Re: [sqlite] storing and comparing dates in sqlite

2012-01-23 Thread Simon Slavin
On 23 Jan 2012, at 5:53pm, Stephan Beal 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

Re: [sqlite] storing and comparing dates in sqlite

2012-01-23 Thread Igor Tandetnik
On 1/23/2012 12:51 PM, dotolee wrote: i'm new to sqlite... and relatively new to php. just wondering what the best way is to store and compare dates. right now i have something like this in my php code: $curr_date_time = strftime('%Y-%m-%d %H:%M:%S'); i'm inserting this into a field in

Re: [sqlite] storing and comparing dates in sqlite

2012-01-23 Thread dotolee
. ___ 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-tp33189769p33190861.html Sent from the SQLite mailing list archive

Re: [sqlite] storing and comparing dates in sqlite

2012-01-23 Thread dotolee
://old.nabble.com/storing-and-comparing-dates-in-sqlite-tp33189769p33190888.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