Gbase 8s内置函数之日期函数

Gbase 8s的内置函数包含标量函数、聚合函数、窗口函数以及其他的函数。

其中标量函数又包含数学函数、字符串函数、日期函数。

本次介绍日期函数及其使用例句:

SYSDATE/CURRENT/TODAY

select sysdate as f_date from dual;

select current as f_date from dual;

select today as f_today from dual;

LAST_DAY

select last_day(date('02/18/2021')) as f_lastday from dual;

YEAR/MONTH/DAY

select year(date('02/18/2021')) as f_year, month(date('02/18/2021')) as f_month, day(date('02/18/2021')) as f_day from dual;

WEEKDAY/QUARTER

select weekday(date('02/18/2021')) as f_weekday, quarter(date('02/18/2021')) as f_quarte from dual;

ADD_MONTH

select add_months(date('02/18/2021'), 2) as f_month1, add_months(date('02/18/2021'), -4) as f_month2 from dual;

TO_DATE

select to_date('2021-06-18 12:34:56', 'yyyy-mm-dd hh:mi:ss') as f_date from dual;

TO_CHAR

select sysdate as f_date1, to_char(sysdate, 'mm/dd/yyyy hh12:mi:ss') as f_date2 from dual;