SAP B1标准字段获取完整年月日时分秒

HANA版本

SELECT CAST(T0."UpdateDate" AS NVARCHAR(10))||' '||TO_TIME(LPAD(T0."UpdateTS",6,'0'),'HHMISS') AS "UpdateDate" 
FROM ORDR

SQL版本

SQL版本： 
**注意：有时候TIME值中不保存秒，需要将TIME值乘以100后进行转换。**
--SAP标准单据转完整的年月日时分秒
SELECT 
  [dbo].[IPS_FullTime](CreateDate,CreateTS) AS CreateTime
FROM ORDR



--函数代码
CREATE FUNCTION [dbo].[IPS_FullTime]
(
  @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