-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
, 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
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
--
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
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
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
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
.
___
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
://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