how can get current time in mysql

how can get current time in mysql


NOW() using in query u can get current time...


<?php
$update = mysql_query("UPDATE test SET lastlogin = NOW() WHERE username = 'test'"); ?>