how to convert date string in vb.net or SQL 2005

declare @dt varchar(100)='27/12/2014'

SELECT PARSENAME(dt,3)+10 AS DayConverted,CHAR(PARSENAME(dt,2)+64) AS MonthConverted,
REVERSE(LEFT(PARSENAME(dt,1),2)) + ':' + REVERSE(RIGHT(PARSENAME(dt,1),2))
FROM (SELECT REPLACE(@dt,'/','.') AS dt)t

---

Please Mark This As Answer if it solved your issue

Please Vote This As Helpful if it helps to solve your issue

Visakh

----------------------------

My Wiki User Page

My MSDN Page

My Personal Blog

My Facebook Page