[sqlalchemy] Re: pysqlite and time support

2006-12-03 Thread Michael Bayer
oops, useless line, took it out. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [E

[sqlalchemy] Re: pysqlite and time support

2006-12-03 Thread Manlio Perillo
ram ha scritto: > As far as I know, sqlite will "support" just about any datetime type > you want, including fractional seconds. > > I put the word "support" in quotes because sqlite doesn't really HAVE a > date, time, or datetime type -- it stores all of those items as > strings, and will then a

[sqlalchemy] Re: pysqlite and time support

2006-12-02 Thread Michael Bayer
unit test is working, it saves and restores this structure from sqlite: insert_data = [ [7, 'jack', datetime.datetime(2005, 11, 10, 0, 0), datetime.date(2005,11,10), datetime.time(12,20,2)], [8, 'roy', datetime.datetime(2005, 11, 10, 11, 52, 35

[sqlalchemy] Re: pysqlite and time support

2006-12-02 Thread ram
As far as I know, sqlite will "support" just about any datetime type you want, including fractional seconds. I put the word "support" in quotes because sqlite doesn't really HAVE a date, time, or datetime type -- it stores all of those items as strings, and will then allow you to pretend that you