Pb with variable date/time

[moulay]

hi,

Sqlserver 2008R2 store datetime in this format : 2009-09-04 15:20:34.623
TD6.0SP1 store datetime in variable(date/time) in this format : 2009-09-04 15:20:34.6230000

when we compare the 2 values it's alaways false, this is a big problem. (update .... where column_datetime = :variable_datetime)

(with sqlserver 2005 that's work fine)

[herve]

Hello,

Do you have a test case that shows the issue ? I have sqlserver 2005 and 20008 I will beable to compare the behavior between the two releases.
I suppose you have created an ODBC databa source: Which driver are you using, SQL Server Native client 10.0 ?

Regards

Hervé

[moulay]

Hi,

Everytime we report a bug, you ask about a test case.

the problem it's very simple, you can create a test case yourself (it's difficult to extract an sql command from a big application).

I'm using odbc 6.01.7600.16385. (sqlnative generate a lot of problems. it's another story).

regards

[herve]

Hello,

I have tested the attached application against SQL SERVER 20005 and SQL SERVER 2008 installed on separate computers.
I can't see any difference between the two SQL SERVER difference. The update is done correctly.


Regards

Hervé

[herve]

Hello,

Here is the attached application.

Regards

Hervé