I reply to all queries on the forums and via email, once per day, Monday to Friday (not weekends).

If you are new here, please see some information on how to ask for support. Thank you!

Reply To: Timezones of Moves

dashed-slug.net › Forums › General discussion › Timezones of Moves › Reply To: Timezones of Moves

May 4, 2019 at 9:51 pm #6260
Anonymous
Inactive

the host will not change the DB time

CONVERT_TZ

will not work for same reason the host will not change they told me to use datesub

i have tried this:

$sql3 = "SELECT COUNT(*) FROM $walletTable WHERE DATE_SUB(created_time, INTERVAL 6 HOUR);)>='$fromDate' AND DATE_SUB(created_time, INTERVAL 6 HOUR);)<='$endDate' AND account='$account' AND category='move' ";

and the variables $fromDate and $endDate look like this 2019-05-03 22:20:20