...Beauty, cleaning, DIY tips and more - free to join!
   Login   Contact us   Site map   Puzzle Club   Ask a question    Newsletter

How To Insert The Current Time With MySQL

Computing : Learning PHP

Finding the current time with mySQL is really simple.

The function NOW() will return the current datetime, and therefore is useful for updating datetime fields that store user sign up dates or log in times for instance.

You can then use something like the output from this field to calculate a 'show online users's function, which simply works out the interval thirty minutes before this and then selects users who have been logged in within that time period.


Profile image!
By: Stephen

  Reply to How To Insert The Current Time With MySQL

  Receive Our Newsletter

PHP and mySQL picture



Questions about PHP and mySQL:

Ask question

More Articles:
How to get the most from your mouse
How to appeal to everyone online
Certificate design