query database for results within a certain time using the user's timezone
How can I query a set of results that belong to a specific time period according to the user's time.

For example: `"select * from table where datestamp like ".date("Y-m-d",strtotime("-1 day"))."%"`

would give me results within the past 24 hours based on the server time. How can I do this query to be based on the user's time rather than the server's time?
query database for results within a certain time using the user's timezone
===

How can I query a set of results that belong to a specific time period according to the user's time.

For example: `"select * from table where datestamp like ".date("Y-m-d",strtotime("-1 day"))."%"`

would give me results within the past 24 hours based on the server time. How can I do this query to be based on the user's time rather than the server's time?