How convert yyyy/dd/mm to yyyy/mm/dd in sql server

Question

I want convert (yyyy/dd/mm) to (yyyy/mm/dd) in sql server

ProcessDate(yyyy/dd/mm)this format Below Data

2014-01-04 00:00:00.000
2014-02-04 00:00:00.000
2014-03-04 00:00:00.000

But I want (yyyy/dd/mm) this format result is 2014-04-01 00:00:00.000((yyyy/dd/mm))

Thanks

sudipta sanyal · Answer

DECLARE @current_date DATETIME SET @current_date = GETDATE() SELECT CONVERT(NVARCHAR(4)Year(@current_date)) + '/' +CONVERT(NVARCHAR(4) DAY(@current_date))+ '/' +CONVERT(NVARCHAR(4) Month(@current_date))