oracle日期类型空值转换
有个需求,把某个日期字段为空的标记为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_tab...
原创
2019-12-16 23:25:40 ·
3018 阅读 ·
0 评论