How to convert dd/mm/yyyy varchar to mm/dd/yyyy varchar in sql server 2005?

Why do you do that to yourself? :)

Handling datetimes as nvarchar in your database does not present any advantage and has huge drawbacks when it comes to sorting or defining time ranges.

Please use the proper data format. The only moment where a string is involved regarding a datetime is on the presentation layer, when the data is presented to the user. Any former use of a datetime as a string is purely nonsense.

Hi,

Hope this will help you.

SELECT CONVERT(VARCHAR,CONVERT(VARCHAR,GETDATE(),103),101)

Try for this

SELECT CONVERT(VARCHAR,GETDATE(),103)

try this.. :)

select convert(varchar,getdate(),103) --dd/mm/yyyy
select convert(varchar,getdate(),101) --mm/dd/yyyy

for info

Convert Datetime to string in many formats[^]

Best site to be refer for Date time format in sql

http://www.sql-server-helper.com/tips/date-formats.aspx[^]