在SQL查询中的Php默认时区

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?

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)"