Pb with variable date/time

General discussion forum about all databases other than SqlBase.
moulay

Pb with variable date/time

Post by moulay » 01 Feb 2011, 15:42

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

Re: Pb with variable date/time

Post by herve » 02 Feb 2011, 14:05

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

Re: Pb with variable date/time

Post by moulay » 02 Feb 2011, 15:12

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

Re: Pb with variable date/time

Post by herve » 04 Feb 2011, 10:21

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

Re: Pb with variable date/time

Post by herve » 04 Feb 2011, 10:27

Hello,

Here is the attached application.

Regards

Hervé
You do not have the required permissions to view the files attached to this post.

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 0 guests