SQLize Online / PHPize Online  /  SQLtest Online

With CTE_Users (userID,RegDate) AS (Select 1 as userID, CAST('20201101' as DATE) as RegDate Union ALL Select 2, CAST('20201201' as DATE) ), CTE_Numbers (Number) AS ( Select 0 AS Number UNION Select 1 UNION Select 2 UNION Select 3 UNION Select 4 UNION Select 5 UNION Select 6 UNION Select 7 UNION Select 8 UNION Select 9 ) Select CTE_Users.userID, CTE_Users.RegDate, (CTE_Users.RegDate + (tab_Numbers1.Number + 10 * tab_Numbers2.Number + 100 * tab_Numbers3.Number + 1000 * tab_Numbers4.Number) * interval '1 day') NewDate from CTE_Users, CTE_Numbers AS tab_Numbers1, CTE_Numbers AS tab_Numbers2, CTE_Numbers AS tab_Numbers3, CTE_Numbers AS tab_Numbers4 Where (CTE_Users.RegDate + (tab_Numbers1.Number + 10 * tab_Numbers2.Number + 100 * tab_Numbers3.Number + 1000 * tab_Numbers4.Number) * interval '1 day') <= current_date AND CAST(((tab_Numbers1.Number + 10 * tab_Numbers2.Number + 100 * tab_Numbers3.Number + 1000 * tab_Numbers4.Number) / 30) as Decimal (15,3)) = (Cast(tab_Numbers1.Number as decimal (15,3)) + 10 * tab_Numbers2.Number + 100 * tab_Numbers3.Number + 1000 * tab_Numbers4.Number)/30 Order By userID, NewDate