datetime formatting output

Chris Angelico rosuav at gmail.com
Sat Feb 8 03:45:41 EST 2014


On Sat, Feb 8, 2014 at 7:40 PM, Igor Korot <ikorot01 at gmail.com> wrote:
> I am reading data from the DB (mySQL) where the datetime field is stored as:
>
> 2012-12-12 23:59:59.099
>
> When I retrieve this date I am successfully see under debugger the dateteime
> object with (2012, 12, 12, 23, 59, 59, 099)
>
> However as you can see from my previous post this date shows up incorrectly
> as:
>
> 2012-12-12 23:59:59.000099
>
> Notice 3 extra 0's in the milliseconds field.

It's not a milliseconds field, that's why :) The real question is: Why
is the datetime you're getting from MySQL putting milliseconds into
the microseconds field? Possibly if you show your code for generating
those datetime objects, that would help.

ChrisA



More information about the Python-list mailing list