select
max(a.create_time)
,to_date(substr(max(create_time),1,10),'yyyy-mm-dd')
,to_date(substr(max(create_time),1,10),'yyyy-mm-dd') -1
from PURCHASE_REQUEST
ORACLE 表中最大日期减 1
最新推荐文章于 2023-12-15 08:47:23 发布
select
max(a.create_time)
,to_date(substr(max(create_time),1,10),'yyyy-mm-dd')
,to_date(substr(max(create_time),1,10),'yyyy-mm-dd') -1
from PURCHASE_REQUEST