Convert Date Format in sql server

[phanikumar32]

Hello all,

Previously in my 'date' column the values are like below.
Date
------
wed o5/23/2013
fri 03/20/2014
------------
------------
etc......
From this type of data i got one output that is
Date
--------
05/23/2013
03/20/2014
---------
---------
etc......
by using the function RIGHT(CONVERT(V ARCHAR(8), Date, 103), 10).


Now from this getting data i want the result as dd/mm/yyyy format.
that is
Date
------
23/05/2013
20/03/2014
---------
---------
etc......

How i will get this type of result.
Please any one guide me to do this one.

Thanks In Advance,
Phani Kumar.

[Rabbit]

Right now your data is in a string data type, first you need to convert it to a date data type, and then convert it back to a string data type with the format 103.

[phanikumar32]

Thanks Rabbit.
I solved my problem with your helpful guidance.