1.复制一张表的数据到另一张表
insert into jct_sys_lock_tbl_new
(BGN_DT, END_DT, TYPE, DESCR, flag, format, range, count)
select BGN_DT, END_DT, TYPE, DESCR, flag, format, range, count
from jct_sys_lock_tbl
也可以:
insert into jct_sys_lock_tbl_new
select *
from jct_sys_lock_tbl
2. jq.grid里面有时间类型数据时展示不了数据;需要把时间转成字符串