数据仓库服务 GaussDB(DWS)-日期和时间函数:TIME FORMAT

时间:2025-02-12 15:05:07

TIME FORMAT

输入

COALESCE(t3.Crt_Tm , CAST('00:00:00' AS TIME FORMAT 'HH:MI:SS'))COALESCE(LI07_F3EABCTLP.CTLREGTIM,CAST('${NULL_TIME}' AS TIME FORMAT 'HH:MI:sS'))trim(cast(cast(a.Ases_Orig_Tm as time format'hhmiss') as varchar(10)))
support.huaweicloud.com/tg-dws/dws_16_0046.html