/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

1 vote193 views2 answers
Laravel update email unique
PHP
0 vote188 views1 answer
Insert views laravel database
PHP
3 votes166 views3 answers
Php replace space with dash
PHP
0 vote215 views2 answers
Php loop backwards through array
PHP
1 vote279 views3 answers
Get all post meta
PHP
1 vote172 views2 answers
Define int variable in php
PHP
0 vote211 views1 answer
Difference between array_merge and +
PHP
0 vote204 views1 answer
How to remove array index from json in php
PHP
1 vote177 views1 answer
User-agent cURL php
PHP
1 vote187 views1 answer
Laravel get next record
PHP