DateTime.Now function question!

[DBC User]

Hi,

I have a program where I store DateTime.Now in a database table. For
some reason in my query the datetime comes up as comma seperated
number. Like dateRequest = 39141,2890187037
This is happening only in a computer in Latin America. Any idea why I
am getting a comma?

Thanks.

 

[Jon Skeet [C# MVP]]

I have a program where I store DateTime.Now in a database table. For
some reason in my query the datetime comes up as comma seperated
number. Like dateRequest = 39141,2890187037
This is happening only in a computer in Latin America. Any idea why I
am getting a comma?

You need to give more information. What is the type of the column in
the database? How are you storing the data in the database? How are you
fetching it?

 

[=?ISO-8859-1?Q?Lasse_V=E5gs=E6ther_Karlsen?=]

You need to give more information. What is the type of the column in
the database? How are you storing the data in the database? How are you
fetching it?

More to the point, how are you verifying that the value is a floating
point number? ie. what are you doing that is showing that number on the
screen, are you looking at it through sql in EM or a similar tool? Are
you inspecting a variable, using Debug.WriteLine? More details are needed.

 

[Guest]

Try changing the culture. Often in Latin and European cultures the comma is
used as en-us uses a period.