problem into format date

Question

0.00/5 (No votes)

See more:

hello,

i want to use "dd/MM/yyyy" format in my project so i changed it into sql display format and on my server and on iis7 LCID to English UK but sql server still use format "MM/dd/yyyy" so

Posted 19-Jun-11 6:21am

mohammed sadeq

Add a Solution

4 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)

Mohd Wasif · Answer 1 · 2011-06-19T18:56:00

Solution 3

select convert(varchar,date,103) as date from tablename

use it while fetching data from sql server.

Posted 19-Jun-11 18:56pm

Mohd Wasif

Comments

uttam2010 20-Jun-11 1:23am

try to <%#DataBinder.Eval(Container.DataItem, "Yrdatecolumn", "{0:dd/MM/yyyy}").ToString()%>

#realJSOP · Answer 2 · 2011-06-19T07:11:00

Sql doesn't care about format unless you're returning the DateTime 's value as a string instead of a DateTime (you should generally avoid returning a DateTime as anything but a DateTime). The front end is where you control the format (how it's displayed). You can do that like this:

C#

// globally accessible culture object
using System.Threading;

System.Threading.Thread.CurrentThread.CurrentUICulture.DateTimeFormat.ShortDatePattern = "dd/MM/yyyy";

Prasanta_Prince · Answer 3 · 2011-06-19T09:26:00

Solution 2

In sql it takes mm/dd/yyyy. But in code you can change it. like,0 string dt=DateTime.Now.ToString("dd/MM/yyyy");

Posted 19-Jun-11 9:26am

Prasanta_Prince

Vijay Radia · Answer 4 · 2011-06-19T20:22:00

Solution 4

Add following under web.config <system.web>

<globalization culture="en-GB"/>

Posted 19-Jun-11 20:22pm

Vijay Radia