select BKP_TIME, to_char(BKP_TIME,'YYYY/MM/DD HH24.MI.SS') as a ,
to_date('2020/8/16 20:41:45','YYYY/MM/DD HH24.MI.SS') as b,
case when BKP_TIME=to_date('2020/8/16 20:41:45','YYYY/MM/DD HH24.MI.SS') then 1 else 0 end as c
from OBT_BOOKING_PLANS where rownum=1
结果:
BKP_TIME | A | B | C |
2020/8/16 20:41:45 | 2020/08/16 20.41.45 | 2020/8/16 20:41:45 | 1 |