DATE_FORMAT
功能
控制datetime或date类型数据输出格式。
语法格式
SQL
SQL> set DATE_FORMAT 任意年月日和中间分隔符的组合示例
SQL
SQL> set DATE_FORMAT yyyy-mm-dd;
SQL> select sysdate();
EXPR1 |
------------------------------------------------------------------------------
2022-10-09 09:30:58.496 AD |
Total 1 records.
Use time:0 ms.
SQL> set DATE_FORMAT mm-YYYY-dd;
SQL> select sysdate();
EXPR1 |
------------------------------------------------------------------------------
10-2022-09 09:31:14.952 AD |
Total 1 records.
Use time:0 ms.
SQL> set DATE_FORMAT mm%YYYY%dd;
SQL> select sysdate();
EXPR1 |
------------------------------------------------------------------------------
10%2022%09 09:31:30.819 AD |
Total 1 records.
Use time:0 ms.