在SQL查询中的Php默认时区

Question

I have this php to set the default timezone on my website:

<?php date_default_timezone_set('Europe/London'); ?>

It works fine if I use <?php echo date("Y-m-d"); ?> etc...

But I am running sql queries that say:

SELECT * from billing_pdf_archive where datetime < DATE(NOW() - INTERVAL 14 DAY)

How can u get the correct timezone for this too?

Answer 1

Or if you don't have admin access to mysql you can actually pass the php current date to replace the SQL NOW() function.

"SELECT * from billing_pdf_archive where datetime < DATE(".date('Y-m-d')." - INTERVAL 14 DAY)"