   [web] SQLite, selecting by time
  I recently started to use sqlite and it have worked pretty well until now. Apparently sqlite stores timestamps (and everything else) as strings and I guess that's what is giving me problems.I have a table with a time column, using DATETIME('now') to get the time, and I want to select all rows made on a certain day or all rows older then a certain date. Something like: "SELECT * FROM table WHERE time > '$sometime'"Obviously this doesn't work very well, so my question is: does anyone know how to work with sqlite timestamps in a proper way?   
  Make sure $datetime is properly formatted. Or make use of SQLite's date and time functions. By the way, internally SQLite stores dates in Julian date format.   