DATE is more of a psuedo-type in SQLite that relies on programmer
convention. It is usually represented as text or as a number of
seconds since the epoch.
sqlite> select typeof(date('now'));
text
sqlite> select typeof(datetime('now'));
text
I think a proper date/time type in SQLite would be a good feature.
--- John Stanton <[EMAIL PROTECTED]> wrote:
> Everybody? Most Sqlite users know that Sqlite implements a DATE type
> and has date support functions.
>
> Karsten Koschinski wrote:
> > Hey,
> >
> > I have a database with a field where dates are stored! As everybody knows
> > SQLite has no
> special date support such as a special datatype for date or something else.
> Now I want to select
> only those records, where the year ist e.g. 2005. How can I do this?
> >
> > "SELECT * FROM database WHERE (EXTRACT DAY FROM date) = 2005" does not work.
> >
> > The database was created with SQLite Analyzer 3.0.8. The datatyp of the
> > field date ist Text.
> >
> > Thanks
> >
> > Karsten
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
