Convert DATETIME to YYYYMMDD

[A819A1L]

Hello,

I'm struggling to work out how to achieve today's date in numbers using GETDATE().

The result I need is 20230524. So today's date in 8 digits as int starting with year: YYYYMMDD

Thanks,

[#2]

I've got it:

SELECT CAST(
		CONCAT(
			RIGHT('0' + RTRIM(YEAR(GETDATE())), 4),
			RIGHT('0' + RTRIM(MONTH(GETDATE())), 2),
			RIGHT('0' + RTRIM(DAY(GETDATE())), 2)
			) AS INT )

If anyone knows of a better way, feel free to educate me :) 

[#3 · Accepted solution]

If anyone knows of a better way, feel free to educate me :) 

---

@A819A1L , there is one:

-- Date format 112 = ISO = YYYYMMDD
SELECT CONVERT(int, CONVERT(char(10), GETDATE(), 112))

[#4]

@olafhelper amazing thanks!

[#5]

Have you looked up and studied the CONVERT() function that OlafHelper posted to learn something new?

[#6]

Hi @Jeff_Moden 

Yes, I did. I have used convert many times in the past, I just couldn't find the code for the format I needed at the time I needed it. So in my haste, I posted here.

As always, I appreciate the information supplied and effort volunteers put in to help me out :thumbs_up: