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. And that is what my post suggested. SQLite doesn't have a date type. The only types are REAL, TEXT, INTEGER, BLOB, and NULL. But, "don't let (that) stop you from using dates very successfully with Sqlite by defining a date type and using the functionality built into the product." ..
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] -----------------------------------------------------------------------------
-- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ --------------------------------------------------------------------- collaborate, communicate, compete ===================================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------