select
time as 原始时间,
substring(to_char(time ,'yyyy-mm-dd hh24:mi:ss'),16,1) as 拿到分钟的第二位,
case when substring(to_char(time ,'yyyy-mm-dd hh24:mi:ss'),16,1) < '5' then '0' else '5' end as "分钟第二位如果大于5则为5否则是0",
substring(to_char(time ,'yyyy-mm-dd hh24:mi:ss'),1,15) as "处了第二个分钟之后的内容",
(substring(to_char(time ,'yyyy-mm-dd hh24:mi:ss'),1,15)||(case when substring(to_char(time ,'yyyy-mm-dd hh24:mi:ss'),16,1) < '5' then '0' else '5' end))::timestamp + interval '5 min' "每五分钟"
from table
postgresql 时间戳切每5分钟
最新推荐文章于 2024-06-04 17:03:38 发布