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, i
qlite> select First_Capture from PIT_manatees where
First_Capturemailto:[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 with dates in SQ
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
199
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
1998-
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 about how to work
5 matches
Mail list logo