Best way to convert Date Format in SQL from yyyymmdd to yyyy-mm-dd format

Question

I have a bunch of dates in the format yyyymmdd without the "-" separated. What is the easiest way to change to yyyy-mm-dd format using only SQL with read access only. i.e 20111230 -> 2011-12-30

One line or optimal performance solution preferable that works in Microsoft SQL

https://technet.microsoft.com/en-us/library/ms187928(v=sql.105).aspx — Gordon Linoff, Jan 12 '18 at 20:51
I think it took you longer to post this question than searching Google! — SS_DBA, Jan 12 '18 at 20:53

score 0 · Answer 1 · answered Jan 12 '18 at 21:02

0

DECLARE @dtr VARCHAR(25) = '20111230'

SELECT CONVERT(char(10),CAST(@dtr AS DATE),126)

-- sqlserver 2012
SELECT FORMAT(CAST(@dtr AS DATE),'yyyy-MM-dd' )

answered Jan 12 '18 at 21:02

Von Abanes

706
1
6
19

Best way to convert Date Format in SQL from yyyymmdd to yyyy-mm-dd format

1 Answers1