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 |
|
Ali T
Starting Member
22 Posts |
 Posted - 2008-08-05 : 06:14:38
|
| dear all;in my table i have a date column with (mm/dd/yyyy) format i want to convert it to (dd/mm/yyyy)/ what should i do?Ali T |
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2008-08-05 : 06:17:27
|
| This is covered in other topics like:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=107995 |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-05 : 13:31:04
|
| And as suggested before, if this is for display purpose please try to do it at your front end application. |
|
|
|
Ali T
Starting Member
22 Posts |
Posted - 2008-08-05 : 16:21:39
|
quote:
Originally posted by visakh16
And as suggested before, if this is for display purpose please try to do it at your front end application.
hii couldn't find my answer in the given link...please help me and if it is possible write me the query.Thanks so muchAli T |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2008-08-05 : 16:24:40
|
| Format your dates at your front-end, where you are ultimately outputting this data. Your data is not "stored" in a particular "format", it is just a set of date values that is returned from your database which ultimately can be easily formatted at your front-end.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
|
|
|
Date format conversion