[SOLVED] MySQL now() vs php date

[Prodigal Son]

Is there any difference from using mysql now() to insert a date vs. using php time()/mktime() and then date? What's the general norm on that?

[DarkWater]

You'd probably want to create a DATETIME column in MySQL, use NOW(), and then DATE_FORMAT to pull out the date how you want it.

[PFMaBiSmAd]

When you can accomplish something in a query using mysql functions, it will save processing time over using php code to do the same task.

[Barand]

From a documentation point of view, using NOW() for current time, or CURDATE() for current date, tells anyone looking at you query code that the query is always based on the current time or date.

 

If there is a '$date' variable in there it could be any date or time and they then have to refer to occurences in the code where the query is called to find that the current date/time is being passed to the query.

 

Conversely, using NOW() or CURDATE() in a query that is always based on the current date/time saves you having to construct it in PHP before calling the query.

[Prodigal Son]

Thanks guy. I thought the opposite, I thought using NOW() was slower and uses more resources or something