WITH RECURSIVE days AS (

SELECT

1 AS days_interval,

'2022-11-15 12:00:00' AS st

), DateRange AS (

SELECT

DATEDIFF(

second,

TIMESTAMP '1970-01-01 00:00:00',

(SELECT st FROM days)

) AS start_time,

CURRENT_TIMESTAMP::timestamp AS end_time,

DATEDIFF(

second,

TIMESTAMP '1970-01-01 00:00:00',

(SELECT st FROM days)

) AS current_time_unix

UNION ALL

SELECT

start_time,

end_time,

current_time_unix + 86400 * (SELECT days_interval FROM days) AS current_time_unix

FROM

DateRange

WHERE

DATEADD(second, 86400 * (SELECT days_interval FROM days), TO_TIMESTAMP_NTZ(current_time_unix)) <= end_time

), DateString AS (

SELECT

'[' || LISTAGG(current_time_unix, ', ') || ']' AS times

FROM

DateRange

),