Difference between MySQL NOW() and PHP date('c')

Question

What is the difference between them? If I use them both on my local machine (windows, xampp), the difference between them is one hour. Why?

Answer 1

You are probably having different timezone for PHP and MySql. You need to set the same timezone for both to get the date time without any difference

Answer 2

there's no difference, but you might have configured different timezones for both (or one of them doesn't use daylight saving time). please check your...

• php configuration
• mysql configuration