Re: Interval time from two dates

[miguel rivero]

Peter Brawley Wrote:
-------------------------------------------------------
> Simplify ...
>
>

> SELECT
> DAYOFWEEK(dStart) AS DOW,
> Time( dStart ) as timeStart,
> Time( dEnd ) as timeEnd,
> cd
> FROM `2019tblCd`
> WHERE cd = 'P'
> AND DAYOFWEEK(dStart) BETWEEN 2 AND 6
> AND Time( dStart ) >= '06:00:00'
> AND Time( dEnd ) <= '08:00:00'
> ORDER BY dStart DESC LIMIT 10;
>

Many thanks, Mr. Peter!