Change SQL date format

Question

I have a column with this format 20150228 and I need to change it to 02/28/2015. Is there any function in SQL to do it.

Thanks

Have you even *tried* `cast`ing or `convert`ing it to a date first? — LittleBobbyTables - Au Revoir, Apr 08 '15 at 15:42
possible duplicate of [sql server convert date to string MM/DD/YYYY](http://stackoverflow.com/questions/11854775/sql-server-convert-date-to-string-mm-dd-yyyy) — LittleBobbyTables - Au Revoir, Apr 08 '15 at 15:47
What **datatype** is your column? If it's already a `DATE` or `DATETIME` - those **don't have any format!**; only when you cast it to a `varchar` is any *formatting* applied .... — marc_s, Apr 08 '15 at 17:11

score 3 · Answer 1 · answered Apr 08 '15 at 15:45

3

You can use this assuming the date is stored as a varchar:

SELECT CONVERT(VARCHAR(50),CONVERT(DATE,'20150228',112),101)

It returns:

02/28/2015

answered Apr 08 '15 at 15:45

Alex

score 0 · Answer 2 · answered Apr 08 '15 at 15:45

0

Use FORMAT function:

SELECT CONVERT(NVARCHAR(10), GETDATE(), 101)

answered Apr 08 '15 at 15:45

Giorgi Nakeuri

2 Answers2