Convert Date Into DD/MM/YY Format [Resolved]

Posted by Pallubhosale under Sql Server on 2/26/2014 | Points: 10 | Views : 737 | Status : [Member] | Replies : 1
Hi,

I want Date format as 24/02/14

I am tryying the below convertion but it is giving me result as 24/02/2014

convert(varchar(12),@EndDate,103)

Pallavi


Responses

Posted by: Bandi on: 2/26/2014 [Member] [MVP] Platinum | Points: 50

Up
0
Down

Resolved
Check

DECLARE @EndDate DATE = getdate()
SELECT convert(varchar(12),@EndDate,103) [DD/MM/YYYY]
SELECT CONVERT(VARCHAR(8), @EndDate , 3) AS [DD/MM/YY]

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Pallubhosale, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response