• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 344
  • Last Modified:

Format date in SQL

Hello,

In Sql Server Management Studio, I have a date field. The data type is "date", and displays like this:

2004-09-03.

I just want it to show like this:

09/03/2004.

Can I just set the field properites up somehow to just record the data like that?

Thanks,
Joel
0
Genius123
Asked:
Genius123
1 Solution
 
Paul JacksonSoftware EngineerCommented:
Put simply no. This is the format in which SQL Server stores Date column data, converting into the required format usually is done in the UI.
0
 
PortletPaulfreelancerCommented:
No is the correct answer, but:
>>"This is the format in which SQL Server stores Date column data"

Please don't think of date/time information as being stored "in a format" because they are not stored this way at all. In sql server date/time information is actually stored as 2 integers.

"formats" apply on top of date/time information - so that we humans can understand them.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now