postgre查询周的sql:select date_trunc('week',current_date + interval '-1 week') as 上周一对应的日期,
date_trunc('week', current_date + interval '-1 week') +interval '6 day' as 上周日对应的日期
postgre查询周的sql
最新推荐文章于 2023-04-23 15:29:40 发布
postgre查询周的sql:select date_trunc('week',current_date + interval '-1 week') as 上周一对应的日期,
date_trunc('week', current_date + interval '-1 week') +interval '6 day' as 上周日对应的日期