MySQL Date Time

[nzkiwi80]

I've got dates in my database which will be set and used for Pacific/Auckland time.

My server is on American time. How can I run a query like this and have it determined by Pacific time?

SELECT * FROM mytable WHERE DATE_FORMAT(StartDate, '%Y-%m-%d') < CURDATE() AND DATE_FORMAT(EndDate, '%Y-%m-%d') > CURDATE()

[Weedpacket]

Depends what "determined by" means, but twenty seconds with the MySQL manual tells me it has a CONVERT_TZ function.

[sneakyimp]

The MySQL documentation tends to be pretty good. You could, for instance, set this in a config file:

default-time-zone='+11:00'

[Steve_R_Jones]

Test 1-2-3