elect tn.dbsname, tn.tabname, ti.*
from systabinfo ti, systabnames tn
where ti.ti_partnum=tn.partnum
and tn.dbsname='ttdb1'
and tn.tabname='t1'
select tn.dbsname, tn.tabname, l2date(ti_created) created,ti.*
from systabinfo ti, systabnames tn
where ti.ti_partnum=tn.partnum
and tn.dbsname='ttdb1'
and tn.tabname='t1'
### l2date函数可以直接转换成日期