Datetime Problem
-
Hi All I have webapplication running at server1 with culture as en-US and Webservice running at another server2 with culture nl-NL.Now I have problem updating and inserting Datatable with column datetime. I am updating SqlServer with sqlBulkCopy option. Thanks Navneet.H
Develop2Program & Program2Develop
-
Hi All I have webapplication running at server1 with culture as en-US and Webservice running at another server2 with culture nl-NL.Now I have problem updating and inserting Datatable with column datetime. I am updating SqlServer with sqlBulkCopy option. Thanks Navneet.H
Develop2Program & Program2Develop
I guess there are many things that could go wrong... One is that you use DateTime.Now instead of DateTime.UtcNow which would be really bad if your servers are in different time zones. Another are formatting problems (DD-MM-YYYY vs MM/DD/YYYY), you can fix this by specifying a fixed format, using CultureInfo.InvariantCulture or "Roundtrip" format.