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 |+-------------------------+