[Pysqlite-users] Re: How to use dates with pysqlite

[Otto Tronarp]

On Tue, 2003-04-01 at 03:38, Gerhard Häring wrote:
> * Gerhard Häring <gh at ghaering.de> [2003-04-01 00:24 +0200]:
> > * Otto Tronarp <otttr440 at student.liu.se> [2003-03-31 23:52 +0200]:
> > > Hi,
> > > 
> > > I can't get dates to work with pysqlite. [...]
> > > >>> cur.execute('create table test (d date)')
> > [...]
> > > >>> cur.execute('select * from test')
> >
> > I'll look into getting more date/time support into CVS soon, [...]
> 
> It's in CVS now. Commit message:
> 
> - Dropped DATETIME type code, added support for INTERVAL type
> - Added support for automatic conversion from
>   DATE/TIME/TIMESTAMP/INTERVAL columns, without the need to use the "--
>   types" magic SQL comment
> - Added tests for this automatic conversion and made the tests for the
>   SQLite type support actually work


Hey, youre quick! 
I just compiled sqlite cvs and it seems to work like I charm, well at
least for my simple example.

Thanks a bunch!

Otto