[Libreoffice-bugs] [Bug 42658] ODBC SQL Server Date Error

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=42658

Lionel Elie Mamane <lionel at mamane.lu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|                            |WORKSFORME

--- Comment #13 from Lionel Elie Mamane <lionel at mamane.lu> 2012-07-13 06:16:39 PDT ---
No news from reporter for several months -> closing.

Works for me, but possibly with different versions of SQL Server, ODBC driver,
different column type (or scale), ...

Anyone reproducing this bug, feel free to reopen *and* provide the needed
details, that is:

 * the type of the column: timestamp, datetime, datetime2?

 * what is the scale of the column

 * output of query:

   SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG='master' AND
   TABLE_SCHEMA='dbo' AND TABLE_NAME='DATA_H1_ASB';

   (replacing 'master', 'dbo', 'DATA_H1_ASB' by the values for the table
   where you encounter the problem)

 * attach a database dump of a small, minimal, database
   that has the problem?

 * What version of SQL Server? What version of the ODBC driver?

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.