PDA

View Full Version : time on MYSQL



imagined
November 16th, 2004, 04:08 PM
Hello!

How can I (using PHP/MYSQL) get the time a INSERT was made. I can get the date using CURDATE() but how can I get the time (minutes, hours, seconds)?

Thanks in advance,

Leonel :hr:

λ
November 16th, 2004, 04:30 PM
*cough* CURTIME() :P

http://www.mysqlfreaks.com/statements/66.php