Loading

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

Nirmal KumarC

11y3k

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

sudipta sanyal11y ago
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))