1. SELECT
    *
FROM
    skdjsj x
WHERE
    NOT REGEXP_LIKE ( x.bmqssj,
                      '[1-2][0-9][0-9][0-9]-[0-1][0-9]-[0-3][0-9][[:space:]][0-2][0-9]:[0-5][0-9]' )
        OR NOT REGEXP_LIKE ( x.bmjssj,
                             '[1-2][0-9][0-9][0-9]-[0-1][0-9]-[0-3][0-9][[:space:]][0-2][0-9]:[0-5][0-9]' )

2.   update skdjsj set bmqssj=to_char(to_date(bmqssj,'yyyy-mm-dd'),'yyyy-mm-dd hh24:mi');
复制