摘要: 两个日期做加减 date_part('day', cast(time1 as TIMESTAMP)- cast(time2 as TIMESTAMP)) to_date(字段1,'yyyMMdd') - to_date(字段2,'yyyMMdd') 算当天第几周 select extract(DOW 阅读全文
posted @ 2022-11-03 10:31 爱做笔记 阅读(934) 评论(0) 推荐(0) 编辑