MySQL provides a NOW()
function that returns the current date and time when executed.
Command:
SELECT NOW() AS 'CURRENT DATE AND TIME';
Expected output:
+-------------------------+
|CURRENT DATE AND TIME |
+-------------------------+
| 2018-03-20 19:22:17 |
+-------------------------+
Visit the DevX Tip Bank