On 8/8/06, Gennan Chen <[EMAIL PROTECTED]> wrote: > I am using MySQL as my DB and it seems datetime field did not store > milliseconds. Is it the correct behavior? Any chance I can hack that/ I need > Milliseconds resolution.
As far as I know, MySQL offers no support for storing such values; the TIME column type will accept an "HH:MM:SS.fraction" input format, but there is an explicit note in the manual that only the hours, minutes and seconds will actually be stored. DATETIME and TIMESTAMP columns do not accept units smaller than one second. Postgres can store values up to a resolution of one microsecond, but I don't know off the top of my head if Django's ORM will specify that much precision. -- "May the forces of evil become confused on the way to your house." -- George Carlin --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---
