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 the database that has been defined as
type TEXT because from what i read, sqlite does not have a date datatype.
but question is how can i write a select statement that will sort by date?
the sql i have right now is not working because it's not treating the field
as a true date...
i want to do something like:
select field1, field2, 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 mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
