/PHP/Mysql between all months days even null

Mysql between all months days even null

DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME

SET @StartDate ='2014-03-01' SET @EndDate = GETDATE()

;WITH Dates(Date) AS
(
    SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, @StartDate)) AS Date
    UNION ALL
    SELECT DATEADD(day, 1, Date) AS Date
    FROM Dates
    WHERE Date <= @EndDate
)
SELECT d.Date, r.Value
FROM Dates d
LEFT JOIN Times r ON d.Date = r.Date

Source: codeproject.com

Similar codes

5 votes271 views2 answers
Get app url in laravel
PHP
1 vote281 views1 answer
How to switch from php7.4 to php7.3 mac
PHP
2 votes283 views1 answer
PHP extension ext-intl
PHP
8 votes322 views3 answers
Magento 2.4.3 how to log
PHP
2 votes289 views2 answers
Laravel list of models
PHP Laravel
10 votes275 views6 answers
Php pdo connection
PHP
6 votes282 views6 answers
Install php 7.4 ubuntu
PHP
0 vote242 views2 answers
Adminlte in laravel 8
PHP
1 vote265 views1 answer
How login with phone in laravel
PHP
2 votes369 views1 answer
Custom rule laravel validation
PHP Laravel