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 ingenious
and permits the user to embed it in neatly into a broad range of
environments from untyped to flexibly typed to strongly typed. For
example we recently integrated Sqlite with Javascript and were gratified
at how well these two tools mapped together. We also use it integrated
into business applications were it supports a fixed point decimal type
with defined precision and scale.
Joe Wilson wrote:
--- 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 of the major internaional date systems.
SQLite does not have a date type. Period.
What you're describing is not a true DATE type, but your own
programming convention when dealing with dates. Your programming
convention relies on functions, date strings and epoch-based floating
point numbers.
If you were correct and SQLite currently supported a DATE type,
then why was this Proposed Incompatible Changes entry added to
the SQLite wiki by DRH?
"Support A DATE Type"
http://www.sqlite.org/cvstrac/wiki?p=ProposedIncompatibleChanges
Because rehashing the old arguments is pointless, here's the old thread:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg20589.html
P Kishor 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 your date strings and convert
them back and forth, manipulate them, etc. Once again, see the link on
working with dates on the SQLite wiki.
____________________________________________________________________________________
We won't tell. Get more on shows you hate to love
(and love to hate): Yahoo! TV's Guilty Pleasures list.
http://tv.yahoo.com/collections/265
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
