Re: pymssql and date format

2006-02-17 Thread Steve Holden
[EMAIL PROTECTED] 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

pymssql and date format

2006-02-16 Thread 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