select * FROM tb_message_news WHERE f_auto_pub_time BETWEEN to_date((now()- interval '1 year')::text,'yyyy-MM-dd') and to_date(now()::text,'yyyy-MM-dd')
Postgresql中to_date()函数使用问题_迷途中的小码农的博客-CSDN博客_postgresql to_date
select * FROM tb_message_news WHERE f_auto_pub_time BETWEEN to_date((now()- interval '1 year')::text,'yyyy-MM-dd') and to_date(now()::text,'yyyy-MM-dd')
Postgresql中to_date()函数使用问题_迷途中的小码农的博客-CSDN博客_postgresql to_date