devxlogo

December 3, 2018

Getting the Current Date and Time in MySQL

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