How to get time

realcoder

i want to get ime of login is there any exact function thorugh that i can get exact time & put in database
i have see a function time() but it's not ruturning the right format ..please tell me how i get exact time thanks

TheoGB

I don't know if it's the most elegant but I use the mktime() function combined with the date() one, though I believe you can make a TIMESTAMP field in MySQL that will simply update with the current Timestamp on every update...

Anyway, syntax is like this:

$date = date("Y-m-d H:i:s", mktime());

THat's for a datetime field. take out the " H:i:s" for a date field only.

NogDog

You can leave out the second argument for date() if you just want the current time. In that case there's no need for the overhead incurred by calling mktime() (which could have just as easily been the time() function, instead). All these are equivalent:

$now = date('Y-m-d H:i:s');
$now = date('Y-m-d H:i:s', time());
$now = date('Y-m-d H:i:s', mktime());

bradgrafelman

TheoGB wrote:
though I believe you can make a TIMESTAMP field in MySQL that will simply update with the current Timestamp on every update

This, IMHO, is the best/easiest solution.

See the MySQL (assuming you're using MySQL) manual page for the TIMESTAMP column. Otherwise, there's no point in generating the time in PHP when MySQL is perfectly capable of doing so itself; see the MySQL manual page Date and Time Functions (e.g. look at the NOW() function).

TheoGB

NogDog;10957171 wrote:
You can leave out the second argument for date() if you just want the current time. In that case there's no need for the overhead incurred by calling mktime() (which could have just as easily been the time() function, instead). All these are equivalent:
$now = date('Y-m-d H:i:s');
$now = date('Y-m-d H:i:s', time());
$now = date('Y-m-d H:i:s', mktime());

Buh! Good point.