/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

61 votes186 views2 answers
Php get intersection of two arrays
PHP
2 votes146 views1 answer
Wp cron disable
PHP Wordpress
0 vote153 views2 answers
If condition in smarty
PHP
1 vote156 views1 answer
Check if session variable exists php
PHP
0 vote156 views2 answers
Laravel santum
PHP
0 vote149 views1 answer
Laravel form validation based on another field value
PHP
1 vote147 views2 answers
Php instanceof
PHP
0 vote167 views1 answer
Check website ssl certificate using php openssl_x509_parse
PHP
0 vote133 views1 answer
Remove WordPress Login error hints
PHP
3 votes148 views1 answer
Carbon parse subday
PHP