/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

0 vote257 views1 answer
How to echo only certain character number in php
PHP
-1 vote301 views1 answer
Echo in console command laravel
PHP Laravel
0 vote239 views2 answers
Hide Categories - Woocommerce Product Page
PHP
16 votes251 views4 answers
Sort multi array php
PHP
0 vote272 views1 answer
Case inside laravel query
PHP Laravel
7 votes322 views2 answers
Laravel mail send to multiple recipients
PHP Laravel
1 vote286 views1 answer
Laravel long description text string
PHP Laravel
0 vote262 views1 answer
Laravel select custom column
PHP
0 vote236 views1 answer
Wp $_post
PHP
1 vote215 views1 answer
Laravel pluck multiple columns
PHP Laravel