select signoff_begin_time time1, to_char(signoff_begin_time,'yyyy-MM-dd HH24:mi:SS') time1_format,
(case when signoff_begin_time > TO_DATE('2011-12-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') then 1 else 0 end) res1,
(case when signoff_begin_time = TO_DATE('2011-12-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') then 1 else 0 end) res2,
(case when signoff_begin_time < TO_DATE('2011-12-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') then 1 else 0 end) res3,
(case when TO_DATE('2011-12-01 00:00:00', 'yyyy-MM-dd HH24:mi:SS') < to_timestamp('2011-12-01 00:00:00', 'yyyy-MM-dd HH24:mi:SS:ff') then 1 else 0 end) res4,
(case when TO_DATE('2011-12-01 00:00:00', 'yyyy-MM-dd HH24:mi:SS') = to_timestamp('2011-12-01 00:00:00', 'yyyy-MM-dd HH24:mi:SS:ff') then 1 else 0 end) res5
from ytstl.t_stl_bill_23 t
where id='B35BAEFF519202D4E0430A01C21BDDA1'
(case when signoff_begin_time > TO_DATE('2011-12-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') then 1 else 0 end) res1,
(case when signoff_begin_time = TO_DATE('2011-12-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') then 1 else 0 end) res2,
(case when signoff_begin_time < TO_DATE('2011-12-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') then 1 else 0 end) res3,
(case when TO_DATE('2011-12-01 00:00:00', 'yyyy-MM-dd HH24:mi:SS') < to_timestamp('2011-12-01 00:00:00', 'yyyy-MM-dd HH24:mi:SS:ff') then 1 else 0 end) res4,
(case when TO_DATE('2011-12-01 00:00:00', 'yyyy-MM-dd HH24:mi:SS') = to_timestamp('2011-12-01 00:00:00', 'yyyy-MM-dd HH24:mi:SS:ff') then 1 else 0 end) res5
from ytstl.t_stl_bill_23 t
where id='B35BAEFF519202D4E0430A01C21BDDA1'