DBA Hub

📋Steps in this guide1/1

Find current timestamp info mysql

Find current data/time on MySQL / MariaDB

mysql configurationintermediate
by MYSQL
13 views
1

Find current timestamp info mysql

Find current data/time on MySQL / MariaDB

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
mysql>
select CURRENT_TIMESTAMP,current_date,localtime(0),localtimestamp(0);
+---------------------+--------------+---------------------+---------------------+
| CURRENT_TIMESTAMP   | current_date | localtime(0)        | localtimestamp(0) |
+---------------------+--------------+---------------------+---------------------+
| 2021-07-04 22:44:33 | 2021-07-04   | 2021-07-04 22:44:33 | 2021-07-04 22:44:33 |
+---------------------+--------------+---------------------+---------------------+
1 row in set (0.00 sec)

Comments (0)

Please to add comments

No comments yet. Be the first to comment!