Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
johnsql
Posting Yak Master
161 Posts |
 Posted - 2007-08-20 : 09:23:26
|
| Buddies, I have a datetime column in a table under format of dd/mm/yyyy. Now, I'd like to convert that column to datetime format like mm/dd/yyyy. How could I do that with a fastest way?Thanks in advance.johnsql |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-20 : 09:27:26
|
Why?DateTimes has no format. They are just offsets to a base date. Do your formatting in your front-end application.If you persist in this, try CONVERT(VARCHAR, dt, 101)
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
convert date time formats