Date Format issue while try to insert date from .net

Question

0.00/5 (No votes)

See more:

.NET3.5

, +

I am using sql server 2008 and .net 2.0 .My Sql Server has MM/DD/yyyy format

when i am trying to insert date data using Query Analyzer it needs mm/dd/yyyy format.But when i use the .net code to pass date data as procedure format i need to change to dd/mm/yyyy format for inserting data same as for querying the date filed from .net need to change the format dd/mm/yyyy to get the data otherwise it throws error. why i need to change my date format .Anybody can answer for it please...

Posted 14-May-12 23:21pm

shibu1234

Add a Solution

Comments

VJ Reddy 16-May-12 3:02am

Thank you for accepting the solution :)

2 solutions

Solution 2

Solution no 1 is very good.

I think you can use SET DATEFORMAT[^] command to change date format for SQL Server.

Posted 15-May-12 4:16am

Maciej Los

Comments

VJ Reddy 15-May-12 10:19am

Good answer. 5!

Maciej Los 15-May-12 10:23am

Thank you ;)

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)

VJ Reddy · Accepted Answer · 2012-05-15T00:31:00

The Date Format in .NET depends upon the CurrentCulture unless a different FormatProvider is specified in the method producing the string output of DateTime value.
In the following code the first two printed DateTime values are governed by the CurrentCulture whereas in the third the FormatProvider given as an argument to ToString method has overridden the CurrentCulture format.

C#

DateTime today = DateTime.Now;
Thread.CurrentThread.CurrentCulture = 
        System.Globalization.CultureInfo.GetCultureInfo("hi-IN");
Console.WriteLine (today);

Thread.CurrentThread.CurrentCulture = 
        System.Globalization.CultureInfo.GetCultureInfo("en-US");
Console.WriteLine (today.ToString());

Console.WriteLine (today.ToString(System.Globalization.CultureInfo
        .GetCultureInfo("hi-IN").DateTimeFormat));

//15-05-2012 15:56:38
//5/15/2012 3:56:38 PM
//15-05-2012 15:56:38

Please try to interpret the above info in the context of your code. I think it may be helpful.