How to convert a date 15-May-2019 in SQL to 2019/05/15 using PATINDEX

Question

I need to convert a date in SQL. The date as is 15-May-2019 and it should display as 2019/05/15.

This is the code I have so far

CASE WHEN WHEN LEN(AgeGroup) > 1 THEN PATINDEX ('%[A-Z]%', date)

I'm not completely sure how to use Patindex. Can someone please help me to fix this?

The use of `patindex()` suggests that this is SQL Server, so I added the tag. — Gordon Linoff, Oct 25 '19 at 11:04
Store the correct type instead - `date`. Dates have no format, they're binary values. Once you have the correct type you can use `FORMAT`, eg `FORMAT(someDate,'YYYY/MM/DD')` — Panagiotis Kanavos, Oct 25 '19 at 12:46

score 2 · Answer 1 · answered Oct 25 '19 at 11:03

2

I would recommend just converting to the date data type:

select try_convert(date, '15-May-2019')

If you want it with slashes, you can produce a string instead:

select replace(convert(varchar(10), try_convert(date, '15-May-2019'), 120), '-', '/')

answered Oct 25 '19 at 11:03

Gordon Linoff

score 0 · Accepted Answer · answered Oct 25 '19 at 12:44

0

SELECT CONVERT(varchar,(cast('15-may-2019' as date)), 111)

answered Oct 25 '19 at 12:44

Nats N

score 0 · Answer 3 · answered Oct 25 '19 at 12:51

0

PATINDEX is slightly overkilling.

Try:

SELECT FORMAT(
      TRY_PARSE('15-May-2019' AS DATE USING 'en-US')
, 'yyyy/MM/dd')

answered Oct 25 '19 at 12:51

Alexander Volok

3 Answers3