有个需求,把某个日期字段为空的标记为N,有值的标记为Y:
select ecu01, ta_ecu03, nvl2(to_char(ta_ecu03), 'Y','N') as x_status,
nvl(ta_ecu03, to_date('1999-05-07 13:23:44', 'yyyy-mm-dd hh24:mi:ss')) as z_status
from t_table
红色的列表示转换成功了
有个需求,把某个日期字段为空的标记为N,有值的标记为Y:
select ecu01, ta_ecu03, nvl2(to_char(ta_ecu03), 'Y','N') as x_status,
nvl(ta_ecu03, to_date('1999-05-07 13:23:44', 'yyyy-mm-dd hh24:mi:ss')) as z_status
from t_table
红色的列表示转换成功了