17,377
社区成员
发帖
与我相关
我的任务
分享
select extract(hour from last_time) from yourtable;
select case when (to_number(extract(minute from last_time)))<7
then to_char(last_time-1,'yyyymmdd')||to_char(extract(hour from last_time)+24)||to_char(last_time,'mi')
else last_time end ,
to_char(last_time-1,'yyyymmdd')||to_char(extract(hour from last_time)+24)||to_char(last_time,'mi'),to_char(extract(hour from last_time)+24)
from km_attendance_info
then to_char(last_time-1,'yyyymmdd')||to_char(extract(hour from last_time)+24)||to_char(last_time,'mi')
我把它换成一个简单的句子,比如last_time就可以执行了,高手出来指点下啊。