Display the Time and Date
Wednesday, February 18th, 2009Displaying the date and time in MySQL, you can achive this using the NOW(), CURDATE() and CURTIME() functions
SELECT NOW( ), CURDATE( ), CURTIME( );
Here is the result generated from my test machine using PHPMyAdmin

mysql date and time example


















