i want yyyy-mm-dd format using sql server

Question

i have date as follows 2014-01-04 00:00:00.000 (yyyy-dd-mm) from the above format i want output as follows 2014-04-01 (yyyy-mm-dd) for that how can i do using sql server.

Espen Skeie · Answer

Hi Nirmal How about this code: SELECT replace ( convert ( varchar  getdate () 111 ) '/' '- ') Kind regards Espen

Nirmal KumarC · Answer

I Tried your query but My date fromat(yyyy/dd/mm) wise same data again came I am provide some data in process date 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

Joginder Banger · Answer

use the dateFormat declare @dates table (parsed date) SET DATEFORMAT ymd; insert into @dates select GETDATE() select * from @dates output parsed 2014-11-14