HANA常用函数

https://help.sap.com/viewer/f1b440ded6144a54ada97ff95dac7adf/2.6/en-US/66a4169b84b2466892e1af9781049836.html
SAP Help Portal
帮助文档

获取日期时间

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

2.SELECT TO_DATE(CURRENT_TIMESTAMP) AS DATE, TO_TIME(CURRENT_TIMESTAMP) AS TIME FROM DUMMY;
DATE TIME
2020-09-24 18:02:19

3.SELECT CAST((TO_DATE(CURRENT_TIMESTAMP)) AS VARCHAR(10)) AS DATE
, CAST((TO_TIME(CURRENT_TIMESTAMP)) AS VARCHAR(10)) AS TIME
FROM DUMMY;
DATE TIME
2022-03-10 16:26:26

4.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

5.拼接字符串
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

日期处理
ADD_DAYS
语法:
ADD_DAYS (d, n)
描述：计算日期d 后n 天的值。
例子：
SELECT ADD_DAYS (TO_DATE (‘2009-12-05’, ‘YYYY-MM-DD’), 30) “add days” FROM DUMMY;
add days
2010-01-04
ADD_MONTHS
语法：
ADD_MONTHS (d, n)
描述：
计算日期d 后n 月的值。
例子：
SELECT ADD_MONTHS (TO_DATE (‘2009-12-05’, ‘YYYY-MM-DD’), 1) “add months” FROM DUMMY
;
add months
2010-01-05
ADD_SECONDS
语法：
ADD_SECONDS (t, n)
描述：
计算时间t 后n 秒的值。
例子：
SELECT ADD_SECONDS (TO_TIMESTAMP (‘2012-01-01 23:30:45’), 60*30) “add seconds” FROM
DUMMY;
add seconds
2012-01-02 00:00:45.0
ADD_YEARS
语法：
ADD_YEARS (d, n)
描述：
计算日期d 后n 年的值。
例子：
SELECT ADD_YEARS (TO_DATE (‘2009-12-05’, ‘YYYY-MM-DD’), 1) “add years” FROM DUMMY;
add years
2010-12-05
CURRENT_DATE
语法：
CURRENT_DATE
描述：
返回当前本地系统日期。
例子：
SELECT CURRENT_DATE “current date” FROM DUMMY;
current date
Nov 19, 2015
CURRENT_TIME
语法：
CURRENT_TIME
描述：
返回当前本地系统时间。
例子：
SELECT CURRENT