SQL版本：示例： SELECT DBO.IPS_FC_ToTime(T0.UpdateDate,T0.UpdateTS) FROM OCRD T0 函数： CREATE FUNCTION [dbo].[IPS_FC_ToTime] ( @DocDate DATETIME, @DocTime INTEGER ) RETURNS NVARCHAR(20) AS BEGIN DECLARE @DateTime NVARCHAR(20) SELECT @DateTime=CONVERT(VARCHAR,@DocDate,23)+' '+LEFT(RIGHT('000000'+CONVERT(VARCHAR,@DocTime),6),2)+':'+LEFT(RIGHT('000000'+CONVERT(VARCHAR,@DocTime),4),2)+':'+RIGHT('000000'+CONVERT(VARCHAR,@DocTime),2) RETURN @DateTime END HANA版本：示例： SELECT CAST(T0."UpdateDate" AS NVARCHAR(10))||' '||TO_TIME(LPAD(T0."UpdateTS",6,'0'),'HHMISS') AS "UpdateDate" FROM "ORDR" T0