1、时间函数 select count(*) from va_visit_info v where --v.st_status1='4' and v.st_input2 = '15220' and trunc(sysdate-cast(v.dt_input2 as date))<15 trunc(date1,date2) 返回一个天数 cast(timestamp as date) timestamp类型转换为带时分秒的date型
trunc
最新推荐文章于 2022-10-23 23:41:02 发布