search

clueboy / pymssql_issues

0 stars 0 forks source link

time type is not supported #103

Open clueboy opened 11 years ago

clueboy commented 11 years ago

From maxim.yegorushkin on November 15, 2012 05:43:33

pymssql supports datetime and date types, but not time for some reason.

Attached is a patch for pymssql-2.0.0b1-dev-20111019 that adds time type support.

Attachment: time.patch

Original issue: http://code.google.com/p/pymssql/issues/detail?id=103

clueboy commented 11 years ago

From maxim.yegorushkin on November 26, 2012 05:44:21

This was an incomplete patch though. It only allowed inserting date's into the database, but not reading them back.

clueboy commented 11 years ago

From rsyring on April 29, 2013 11:16:20

The reason we don't support time types is because SQL Server didn't support them until 2008. And, I don't think FreeTDS supports the new types yet.

I sent an email to the FreeTDS list to see what the status of support for this is in FreeTDS.

Until FreeTDS supports this, I don't want to support it. I don't want to be making assumptions in pymssql about how to save time to datetime in sql server and back. Let the application developer or DB framework handle that.

clueboy commented 11 years ago

From msabramo on August 15, 2013 13:32:08

Hi Randy,

Did FreeTDS ever respond? Do you think this is something we should add support for or should this be closed as "won't fix"?

clueboy commented 11 years ago

From randy.syring@lev12.com on August 16, 2013 07:47:35

Sent to FreeTDS list:

Hi Gents,

Can you give me a status update on support for the Time type? After the exchange below, the email thread takes a pretty technical turn. From that discussion, it sounds like the Time type is not yet supported in dblib?

Still trying to figure out what to do with this issue: http://code.google.com/p/pymssql/issues/detail?id=103 Thanks.