pgsql和其他数据库函数有不一致的地方,以实际需求为准
now()-Interval ' 1 day '
查询过去1天到现在
floor(date_part('time',sj)/?)*?
此函数用来处理时间段,需要处理到哪里就填到哪里。
分钟填minute,小时填hour,依次类推
--截取数据库时间年月日
SELECT EXTRACT
( YEAR FROM CURRENT_DATE ) AS YEAR,
EXTRACT ( MONTH FROM CURRENT_DATE ) AS MONTH,
EXTRACT ( DAY FROM CURRENT_DATE ) AS DAY;
--最近一周【不包括今天】
SELECT EXTRACT
( dow FROM zjyz ) AS week
FROM
generate_series ( ( now( ) - INTERVAL '7 day' ), ( now( ) - INTERVAL '1 day' ), '1 days' ) AS zjyz;
--前几天是周几
SELECT EXTRACT
(
dow
FROM
( now() - INTERVAL '1 day' )) AS weekday;