MySql和PHP之间的日期/时间差异？

Question

I have this table

Name                       Birth_Date            Register_Date
---------------------------------------------------------------
Ali                       1990-03-22             2010-03-1 15:1:42
Ali1                      1991-07-18             2010-03-2 12:44:2

When I inserted these values, I inserted the Birth_Date as a String such as '1990-03-22', and I used 'NOW()' for Register_Date.

NOW() will generate the current datetime according to the MySql Server.

Now when I try to get the time between the current date and the Register_Date (Time passed since he registered), I use the following:

SELECT YEAR(CURDATE())-YEAR(register_date) ...

In PHP, if I wanted to do that, I suppose I have to get the current date: date('Y-m-d H:i:s');

My question is, is there a difference between calculating the date difference (between a date and today) via MySql or via PHP?

Currently, on my localhost (XAMPP), CURDATE() and date(..) generates the same date, but will it generate the same date for other users when my website goes online?

Answer 1

If both your mysql and PHP server are operating on the same timezone and have their clocks properly synchronized, you wont have an issue.