试着这样做：

select 
VARCHAR_FORMAT( TIMESTAMP_FORMAT(cast(yourcolumn as varchar(8)), 'YYYYMMDD') , 'MMDDYYYY') 
from yourtable

但是你你想要一个真正的约会去做吧：

select 
DATE( TIMESTAMP_FORMAT(cast(yourcolumn as varchar(8)), 'YYYYMMDD')) 
from yourtable

尝试使用此查询查找日期

select 
date(timestamp_format(char(yourcolumn+19000000), 'YYYYMMDD')) 
from yourtable

为了得到时间

select 
cast( substr( right( '00' || yourcolumn, 6) ,1,2) || ':' || substr( right( '00' || yourcolumn, 6) ,3,2) || ':' || substr( right( '00' || yourcolumn, 6) ,5,2) as time) 
from yourtable