Re: [sqlite] extracting and comparing dates

2007-06-04 Thread John Stanton
ted contact [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Fonnesbeck Sent: Monday, June 04, 2007 3:04 PM To: sqlite-users@sqlite.org Subject: [sqlite] extracting and comparing dates I'm at a complete loss about how to work wi

Re: [sqlite] extracting and comparing dates

2007-06-04 Thread John Stanton
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 -mm-dd format: sqlite> select First_Capture from PIT_manatees limit 5; 1997-6-17 1998-5-6 1997-6-24

Re: [sqlite] extracting and comparing dates

2007-06-04 Thread Rich Shepard
On Mon, 4 Jun 2007, 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 -mm-dd format: sqlite> select First_Capture from PIT_manatees limit 5; 1997-6-17

RE: [sqlite] extracting and comparing dates

2007-06-04 Thread Samuel R. Neff
on D.C. metro area. If interested contact [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Fonnesbeck Sent: Monday, June 04, 2007 3:04 PM To: sqlite-users@sqlite.org Subject: [sqlite] extracting and comparing dates I'm at a complete loss

[sqlite] extracting and comparing dates

2007-06-04 Thread Chris Fonnesbeck
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 -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,