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]

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:
'2006-02-16 17:50:19'

regards
Steve

 

[test-test-test]

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:
'2006-02-16 17:50:19'

regards
Steve

Wondering is that possible to avoid this by add conversion in raw SQLs so that no need apply extra logic in Codes