南大通用GBase 8a对date类型做函数运算时返回类型控制

该参数用于设置对date类型做函数运算时，是否返回包含时分秒的datetime类型，还是String 字符串类型。默认datetime。

参数

_gbase_date_func_type

默认值

1

Session

Y

样例

gbase> select adddate('2020-01-01',interval 1 year);
+---------------------------------------+
| adddate('2020-01-01',interval 1 year) |
+---------------------------------------+
| 2021-01-01 00:00:00                   |
+---------------------------------------+
1 row in set (Elapsed: 00:00:00.00)

gbase> set _gbase_date_func_type = 0;
Query OK, 0 rows affected (Elapsed: 00:00:00.00)

gbase> select adddate('2020-01-01',interval 1 year);
+---------------------------------------+
| adddate('2020-01-01',interval 1 year) |
+---------------------------------------+
| 2021-01-01                            |
+---------------------------------------+
1 row in set (Elapsed: 00:00:00.00)