Chris Fonnesbeck wrote:
I'm at a complete loss about how to work with dates in SQLite. The documentation doesnt seem to be helping me. I have a table with some date fields, in the proper yyyy-mm-dd format:sqlite> select First_Capture from PIT_manatees limit 5; 1997-6-17 1998-5-6 1997-6-24 1998-5-6 2000-3-15 however, it does not respond properly to comparisons to dates: sqlite> select First_Capture from PIT_manatees where First_Capture<2000-1-1 limit 5; sqlite> this doesnt work either: sqlite> select First_Capture from PIT_manatees where First_Capture<date('2000-1-1') limit 5; sqlite> note that these columns are in the 'date' format. How does one extract years, months, dates from tables in SQLite? The 'extract' function also seems not to work. Any help most appreciated.
Store the dates in the internal Sqlite julian mode. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
