使用cast 强制将时间戳类型转成date类型;
select to_char(cast(birthday as date),'yyyy-mm-dd') from 表
select to_char(birthday,'yyyy-mm-dd') birthday from sutdent
