Skip to Content.
Sympa Menu

freetds - [freetds] More info on Datetime issue

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Casey Allen Shobe <cshobe AT osss.net>
  • To: TDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] More info on Datetime issue
  • Date: Thu, 11 Mar 2004 15:27:46 -0500

I have found that the ability to insert a sub-second timestamp into MSSQL silently fails when anything beyond 3 digits is attempted, but succeeds when only 3 digits are given (or any digits following those three happen to equal zero).

'2004-03-10 09:56:45.250' inserts correctly
'2004-03-10 09:56:45.250001' fails silently
'2004-03-10 09:56:45.250000' inserts correctly

- Casey




Archive powered by MHonArc 2.6.24.

Top of Page