select a.*,b.login_name,b.user_name,c.cat_name from sec.t_post_message a,sec.t_user b,sec.t_comm_cfg c where a.user_id=b.id and a.type_id=c.cat_id and inpool='0' and time_type='1' and abs((EXTRACT(EPOCH from LOCALTIMESTAMP(0))-EXTRACT(EPOCH from cast(a.send_date||' '||a.send_time||':00' as timestamp(0))))/60)<5
Postgresql 时间相减求 秒、分、小时数
最新推荐文章于 2024-07-04 16:34:12 发布