pymssql and date format

[eight02645999]

hi
i am using pymmsql to query a date column in MSSQL database table.
However the result shows for example
(datetime.datetime(2006, 2, 16, 17, 50, 19) which is supposed to be
2006-02-16 17:50:19.000
anyway to correct query a date column using pymssql so that it gives
the correct date format? thanks

[Steve Holden]

ei***********@yahoo.com wrote:

hi
i am using pymmsql to query a date column in MSSQL database table.
However the result shows for example
(datetime.datetime(2006, 2, 16, 17, 50, 19) which is supposed to be
2006-02-16 17:50:19.000
anyway to correct query a date column using pymssql so that it gives
the correct date format? thanks

It doesn't return a format, it returns a value. I presume you are saying
that you don't like the way the value prints? Use str() on it:

str(datetime.datetime(2006, 2, 16, 17, 50, 19))

'2006-02-16 17:50:19'

regards
Steve
--
Steve Holden [phone] [phone]
Holden Web LLC www.holdenweb.com
PyCon TX 2006 www.python.org/pycon/