Case Substr (to_char(date,’yyyy-mm-dd hh:mi:as’),12,2)
When ‘00’ then ‘0点’
When ‘12’ then ‘12点’
Else ‘’ end
Case Substr (to_char(date,'yyyy-mm-dd hh24:mi:ss'),12,2)
When '00' then '0点'
When '12' then '12点'
Else '' end
你把hh 修改成HH