1、时间戳,毫秒
select to_timestamp('2017-08-28 13:48:23.246','yyyy-MM-dd HH24:mi:ss.MS')::timestamp without time zone;
2、获取本月日期序列
select to_char(date(day),'yyyy-MM-dd') as monthDate
from
generate_series(date_trunc('month',to_date(to_char(now(),'yyyyMMdd'),'yyyyMMdd')),
to_date(to_char(now() + interval '-1 day' ,'yyyyMMdd'),'yyyyMMdd'),'1 day') as tt(day)
© 著作权归作者所有