集团数仓要求的日期格式为:STRING yyyyMMddhhssmm
例如:20200924175407
SAP HANA中日期格式为:TIMESTAMP yyyy-MM-dd hh:ss:mm
例如:
SELECT CURRENT_TIMESTAMP FROM DUMMY ;
2020-09-24 17:55:33
- 获取日期和时间
SELECT
TO_DATE(CURRENT_TIMESTAMP) AS DATE
, TO_TIME(CURRENT_TIMESTAMP) AS TIME
FROM DUMMY
;
结果:
DATE | TIME |
---|---|
2020-09-24 | 18:02:19 |
- 类型转换
SELECT
CAST((TO_DATE(CURRENT_TIMESTAMP)) AS VARCHAR(10)) AS DATE
, CAST((TO_TIME(CURRENT_TIMESTAMP)) AS VARCHAR(10)) AS TIME
FROM DUMMY
;
- 字符替换
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 |
- 字符串拼接
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 |