I'm having a problem with my dates in sql server. Right how the dates in the database have several different formats such as...
12/25/2004 00:00:00
1/1/2004
2/2/86
1122003
What I am trying to do is format the complete column permanently so that whenever i run a query for the dates, the correct data will pop up. I've tried using the convert function, but all that does is convert one date at that particular time. I want to be able to convert all the dates in that particular column permanently to look like mm/dd/yyyy. Please Help:(

Is the column of type DateTime? You could do: SELECT convert(varchar(10), column, 101) as column From table which will select the entire column and format them all at once.

================================================== =========
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========

      I have this problem too..... help me???

The column is of type DateTime.

Based on your sample data, I don't think that the column is of DateTime data type. If it is, then you don't have to worry about anything because internally, SQL Server stores DateTime data types as 2 4-byte integers. For other questions about datetime data types in SQL Server, you can refer to the following link:

http://www.sql-server-helper.com/faq/dates-p01.aspx

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp