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

时间:2024-10-26 11:41:21

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