How to select Date format like MM/DD/YYYY from sql server in query

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi,

I am developing an asp web application in that many web forms have Date field, i am giveing date and seveing in sql server 2005 database it storing date like MM/DD/YYYY. But whenever i retraives that same deta and displaying into textbox that time date format is like DD/MM/YYYY.

Because of this format change asp web application throwing format exception.

Please anybody let me to how retrive date value in MM/DD/YYYY format from sql server.

Thanks
Uday

Posted 21-Oct-11 21:43pm

udaysimha

Add a Solution

Comments

Amir Mahfoozi 22-Oct-11 4:51am

did you succeed ?

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)

Abhinav S · Answer 1 · 2011-10-21T21:49:00

Solution 1

Have a look at using CAST and CONVERT - http://msdn.microsoft.com/en-us/library/aa226054(v=sql.80).aspx[^].

More specifically for your case, have a look at code 101.

Posted 21-Oct-11 21:49pm

Abhinav S

OriginalGriff · Answer 2 · 2011-10-21T21:49:00

Firstly, You should make sure that you are storing your data in SQL Date fields - I assume you are or you would not see the problem you describe.

Secondly, you should not be making decisions about display date format at all, and you should not assume that the user is entering dates in any particular format either. Bear in mind that the users of a website could be anywhere in the world, and will expect dates to be entered and displayed in their current local format. So, don't use a textbox: use a Calender control instead - that will also validate the dates entered by the user to ensure that they actually exist.

Amir Mahfoozi · Answer 3 · 2011-10-21T21:50:00

Solution 3

use this in your select statement :

SQL

CONVERT(char(10), OrderDate, 101) newdate

want to know more about 101 ? read here :
http://msdn.microsoft.com/en-us/library/ms187928.aspx[^]

Posted 21-Oct-11 21:50pm

Amir Mahfoozi

Updated 21-Oct-11 21:51pm

v2