1.查看当前系统日期

SQL> select to_char(sysdate, 'yyyy-mm-dd') from dual;

TO_CHAR(SYSDATE,'YYYY-MM-DD')
------------------------------
2021-11-29

mysql> select curdate();
+------------+
| curdate()  |
+------------+
| 2021-11-29 |
+------------+
1 row in set (0.00 sec)

2.查看当前时间时间

SQL> select to_char(sysdate, 'hh24:mi:ss') from dual;

TO_CHAR(SYSDATE,'HH24:MI
------------------------
22:15:10

mysql> select current_time;
+--------------+
| current_time |
+--------------+
| 22:16:19     |
+--------------+
1 row in set (0.00 sec)

3.查询系统日期和时间：

SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;

TO_CHAR(SYSDATE,'YYYY-MM-DDHH24:MI:SS')
---------------------------------------------------------
2021-11-29 22:19:46

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2021-11-29 22:20:08 |
+---------------------+
1 row in set (0.00 sec)

mysql> select sysdate();
+---------------------+
| sysdate()           |
+---------------------+
| 2021-11-29 22:20:17 |
+---------------------+
1 row in set (0.00 sec)

4.时间戳

SQL> select systimestamp from dual;

SYSTIMESTAMP
---------------------------------------------------------------------------
29-NOV-21 10.20.53.696960 PM +08:00

mysql> select current_timestamp;
+---------------------+
| current_timestamp   |
+---------------------+
| 2021-11-29 22:21:27 |
+---------------------+
1 row in set (0.00 sec)

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL