Displaying 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

Bookmark It

Hide Sites