select notice_id notice_title notice_type castnotice_content as char as notice_content status create_by create_time update_by update_time remark from sys_notice 转达梦sql

SELECT notice_id, notice_title, notice_type, CAST(notice_content AS CHAR) AS notice_content, status, create_by, create_time, update_by, update_time, remark FROM sys_notice;