--- 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] -----------------------------------------------------------------------------
