SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
select extract(epoch from '2022.10.27 13:26:00'::timestamp); with recursive weeks(w) as ( select date_trunc('week', timezone('UTC', to_timestamp((1666877160)))) + interval '7 day' union all select date_trunc('week', timezone('UTC', w)) + interval '7 day' where w < current_date ) select * from weeks;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear