我自己写的代码是这样的,但是不可以运行,不知道为什么!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
extract(hour from last_time)这句应该不行吧? 你试试select extract(hour from last_time) from yourtable;如果不行,那问题就因该出在这句了
last_time跟first_time都是timestemp型的,那句话是没有问题的,是在then后面那段语句出了问题,不知道是不是then后面不能用这样的逻辑 就这句,then to_char(last_time-1,'yyyymmdd')||to_char(extract(hour from last_time)+24)||to_char(last_time,'mi') 我把它换成一个简单的句子,比如last_time就可以执行了,高手出来指点下啊。
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
你试试select extract(hour from last_time) from yourtable;如果不行,那问题就因该出在这句了
就这句,then to_char(last_time-1,'yyyymmdd')||to_char(extract(hour from last_time)+24)||to_char(last_time,'mi')
我把它换成一个简单的句子,比如last_time就可以执行了,高手出来指点下啊。