dutch date format

Question

0.00/5 (No votes)

See more:

Hi,

I am working on a ASP.net c# project for Dutch client that uses sqlserver 2008 database.

The database server is having local Dutch settings.

When i try to insert the date into one of the date fields in a table using my development server with connection to dutch database server, the record gets inserted.

But if i host the site into the production server and use the database of production server, the date field throws error

Pls help

thanks in advance

Posted 18-Mar-10 4:36am

Member 2068169

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2010-03-18T04:38:00

Solution 1

Member 2068169 wrote:
the date field throws error

How is anyone expected to guess what the error is?

Posted 18-Mar-10 4:38am

Richard MacCutchan

Avi Berger · Answer 2 · 2010-03-18T05:14:00

Solution 2

Presumably, there is a difference in locale settings between the machines. It sounds like you are already thinking about this. So have you checked the settings for what date/time format is used on each of the machines involved?

Edit: See Luc Pattyn's answer. It is better.

Posted 18-Mar-10 5:14am

Avi Berger

Updated 18-Mar-10 6:56am

v2

Luc Pattyn · Answer 3 · 2010-03-18T06:01:00

There are three steps to avoid such problems:

1.
your datebase should store dates and date/times using the appropriate field data type, and NOT as strings; if the database you use doesn't have an appropriate type, you should either switch to another database, or use strings with a fixed datetime format (Google for ISO 8601).

2.
your database operations should be parameterized; don't use date literals (which are bound to include a formatting convention), use SqlParameters instead (or whatever applies to your database).

3.
Your app should take care of date formatting anytime your user has to input a date as a string (did you consider using a DateTimePicker?) or your app has to output a textual date.
In most situations, the decent thing to do is to apply the machine's regional settings, as that is the choice the user has made.

:)