SAP HANA中日期格式转换

集团数仓要求的日期格式为：STRING yyyyMMddhhssmm
例如：20200924175407
SAP HANA中日期格式为：TIMESTAMP yyyy-MM-dd hh:ss:mm
例如：

SELECT CURRENT_TIMESTAMP FROM DUMMY ; 
2020-09-24 17:55:33

1. 获取日期和时间

SELECT 
	  TO_DATE(CURRENT_TIMESTAMP) AS DATE
	, TO_TIME(CURRENT_TIMESTAMP) AS TIME 
FROM DUMMY
;

结果：

DATE	TIME
2020-09-24	18:02:19

2. 类型转换

SELECT 
	  CAST((TO_DATE(CURRENT_TIMESTAMP)) AS VARCHAR(10)) AS DATE
	, CAST((TO_TIME(CURRENT_TIMESTAMP)) AS VARCHAR(10)) AS TIME 
FROM DUMMY
;		  

3. 字符替换

SELECT 
	  REPLACE(CAST((TO_DATE(CURRENT_TIMESTAMP)) AS VARCHAR(10)),'-','') AS DATE
	, REPLACE(CAST((TO_TIME(CURRENT_TIMESTAMP)) AS VARCHAR(8)),':','') AS TIME 
FROM DUMMY
;

结果：

DATE	TIME
20200924	181021

4. 字符串拼接

SELECT 
    CONCAT(REPLACE(CAST((TO_DATE(CURRENT_TIMESTAMP)) AS VARCHAR(10)),'-',''),
        REPLACE(CAST((TO_TIME(CURRENT_TIMESTAMP)) AS VARCHAR(10)),':','')) AS DATETIME
FROM DUMMY
;

结果：

DATETIME
20200924182020