larsbloch
10/5/2017 - 5:56 PM

Snippets of date converting code - Dato, 120, konvertere

Snippets of date converting code - Dato, 120, konvertere

DateConverting.sql
content_copyfile_download
SELECT convert(date, '2016-10-23', 120)

SELECT convert(date, CAST(2016 as varchar(4)) + '-' + CAST(10 as Varchar(2)) + '-' + CAST(23 as varchar(2)), 120)