In my project I allow to register anyone and he can schedule a test on certain date.

But problem is when registered user set a test on a date assuming local time,
but the server which hosting the site is in U.S hense there is mismatch occurs.

Can anybody tell me how other web applications (running accross multiple countries)accept and store dates in databases.

Recommended Answers

All 2 Replies

while Saving the Data To the
Database please write the following like in the .cs file.
Hope this may help u

CultureInfo cinfo = new CultureInfo("hi-IN");

CultureInfo Provides information about a specific culture (called a "locale" for unmanaged code development). The information includes the names for the culture, the
writing system, the calendar used, and formatting for dates and sort strings.

You might also try converting to universal time when storing in the database, and then applying the time zone when pulling it out.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.