On 6/5/07, John Stanton <[EMAIL PROTECTED]> wrote:
OK Sqlite doesn't have a date type, period. Just as it doesn't have
other types, but don't let it it stop you from using dates very
successfully with Sqlite by defining a date type and using the
functionally built into the product.
Indeed.
OK Sqlite doesn't have a date type, period. Just as it doesn't have
other types, but don't let it it stop you from using dates very
successfully with Sqlite by defining a date type and using the
functionally built into the product.
The Sqlite storage model plus its style of declared types is
--- John Stanton <[EMAIL PROTECTED]> wrote:
> Sqlite does have a date format, it is physically a 64 bit floating point
> number. There are functions to transform in and out of that format to
> present dates as required by the user. The Sqlite date format uses a
> magib epoch which matches all
Look at the date functions, the file date.c is self explanatory and
lists the reference for the date type. The underlying type for a date
is a float, so that may be how you missed the date details.
P Kishor wrote:
On 6/4/07, John Stanton <[EMAIL PROTECTED]> wrote:
Sqlite does have a date
Chris Fonnesbeck wrote:
On 6/4/07, P Kishor <[EMAIL PROTECTED]> wrote:
There is no "DATE" format in SQLite. Dates are stored as strings. The
only formats SQLite knows and understands are TEXT, REAL, INTEGER,
BLOB, and NULL (see the link on datatypes). On the other hand, there
are built-in
On 6/4/07, John Stanton <[EMAIL PROTECTED]> wrote:
Sqlite does have a date format, it is physically a 64 bit floating point
number.
If that is the case, I would love to see the documentation on that. As
far as I can see, there are only TEXT, REAL, INTEGER, BLOB, NULL types
supported.
There
Sqlite does have a date format, it is physically a 64 bit floating point
number. There are functions to transform in and out of that format to
present dates as required by the user. The Sqlite date format uses a
magib epoch which matches all of the major internaional date systems.
P Kishor
.
Be sure to see: http://www.sqlite.org/datatype3.html
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Chris Fonnesbeck
Sent: Monday, June 04, 2007 3:24 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] baffled by dates
Wow, thanks. So, why does
What you want is here:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
I'm thinking you want:
select First_Capture from PIT_manatees where date(First_Capture) <
'2000-1-1' limit 5;
- Scott
Chris Fonnesbeck wrote:
> I'm at a complete loss about how to work with dates in SQLite. The
>
On 6/4/07, P Kishor <[EMAIL PROTECTED]> wrote:
There is no "DATE" format in SQLite. Dates are stored as strings. The
only formats SQLite knows and understands are TEXT, REAL, INTEGER,
BLOB, and NULL (see the link on datatypes). On the other hand, there
are built-in functions that can act on
There is no "DATE" format in SQLite. Dates are stored as strings. The
only formats SQLite knows and understands are TEXT, REAL, INTEGER,
BLOB, and NULL (see the link on datatypes). On the other hand, there
are built-in functions that can act on your date strings and convert
them back and forth,
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,
12 matches
Mail list logo