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've stored a datetime by just giving you back exactly what you put in. Sqlite also will allow some simple date arithmetic and other date expressions assuming it can understand the datetime format you've used - what it understands is in the SQLite docs. I had at one point changed the SQlite datetime parser when I added a patch for smalldatetime and time support, and it was pretty easy - it's just a datetime string parser. In fact, I remember adding explicit support for microseconds, which were not supported by strptime. Is it not working right? Rick On Dec 2, 3:27 pm, Manlio Perillo <[EMAIL PROTECTED]> wrote: > Regards. > > From the code in qlalchemy.databases.sqlite.py it seems that SQLAlchemy > does not support things like: > > 12:30:00.30 > > That is: seconds with a fractional part. > > Any reasons for doing this? > > Manlio Perillo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
