MariaDB [(none)]> SELECT now(), sysdate(), unix_timestamp();
|
+---------------------+---------------------+------------------+
|
| now() | sysdate() | unix_timestamp() |
|
+---------------------+---------------------+------------------+
|
| 2019-07-16 18:36:29 | 2019-07-16 18:36:29 | 1563302189 |
|
+---------------------+---------------------+------------------+
|
1 row in set (0.001 sec)
|
|
MariaDB [(none)]> \! date 07152000
|
Mon Jul 15 20:00:00 UTC 2019
|
|
MariaDB [(none)]> SELECT now(), sysdate(), unix_timestamp();
|
+---------------------+---------------------+------------------+
|
| now() | sysdate() | unix_timestamp() |
|
+---------------------+---------------------+------------------+
|
| 2019-07-16 18:36:31 | 2019-07-15 20:00:00 | 1563302191 |
|
+---------------------+---------------------+------------------+
|
1 row in set (0.000 sec)
|
|
MariaDB [(none)]> SELECT sleep(2);
|
+----------+
|
| sleep(2) |
|
+----------+
|
| 0 |
|
+----------+
|
1 row in set (2.000 sec)
|
|
MariaDB [(none)]> SELECT now(), sysdate(), unix_timestamp();
|
+---------------------+---------------------+------------------+
|
| now() | sysdate() | unix_timestamp() |
|
+---------------------+---------------------+------------------+
|
| 2019-07-16 18:36:31 | 2019-07-15 20:00:02 | 1563302191 |
|
+---------------------+---------------------+------------------+
|