Loading

i want yyyy-mm-dd format using sql server

i want yyyy-mm-dd format using sql server

Nirmal KumarC

Nirmal KumarC

11y1.2k

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.

3 Replies

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

Nirmal KumarC11y ago
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
Espen Skeie11y ago
Hi Nirmal

How about this code:
```
SELECT replace(convert(varchar, getdate(), 111), '/', '-')
```
Kind regards
Espen
Joginder Banger11y ago
use the dateFormat

declare @dates table (parsed date)
SET DATEFORMAT ymd;
insert into @dates
select GETDATE()

select * from @dates

output
parsed
2014-11-14