Oracle带时间的日期格式
例子:更新鼎捷T100中bom变更单的生效日期
select * from bmfa_t where bmfastus='W' AND bmfadocno='21040024'
UPDATE bmfa_t SET bmfa005=to_date('2021-08-30 00:00:01','yyyy-mm-dd hh24:mi:ss') where bmfastus='W' AND bmfadocno='21040024'
Oracle带时间的日期格式
例子:更新鼎捷T100中bom变更单的生效日期
select * from bmfa_t where bmfastus='W' AND bmfadocno='21040024'
UPDATE bmfa_t SET bmfa005=to_date('2021-08-30 00:00:01','yyyy-mm-dd hh24:mi:ss') where bmfastus='W' AND bmfadocno='21040024'