select CONVERT(VARCHAR(8),DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0),112) as from_date

http://zarez.net/?p=2462

Convert from string back to a date object ```tsql SELECT DAY(EOMONTH(GETDATE())) DECLARE @year varchar SET @year = '2024' DECLARE @month varchar SET @month = '08' SELECT DAY(EOMONTH(convert(datetime, CONCAT(@year,@month,'01'), 112))) SELECT convert(datetime, '20240915', 112) ``` 10.11.17

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024