目录
-
获取当前时间
SELECT now() as timestamp
-
获取本周时间
获取本周周一日期
SELECT to_char(CURRENT_DATE +cast(-1*(TO_NUMBER(to_char(CURRENT_DATE,'D'),'99')-2) ||' days' as interval),'yyyy-mm-dd');
获取本周周日日期
SELECT to_char(CURRENT_DATE +cast(-1*(TO_NUMBER(to_char(CURRENT_DATE,'D'),'99')-2)+6 ||' days' as interval),'yyyy-mm-dd')
-
获取本月
select to_char((SELECT now() as timestamp),'mm')
-
获取上月
select to_char((select now() - interval '1 month'),'mm')
-
获取今年
select to_char((SELECT now() as timestamp),'yyyy')
-
获取去年
select to_char((select now() - interval '1 years'),'yyyy')