dashed-slug.net › Forums › General discussion › Timezones of Moves › Reply To: Timezones of Moves
May 3, 2019 at 6:39 pm
#6257
Anonymous
Inactive
they both are going in at the same time which is the + 6 hours
everything done by the wallet is +6 hours ahead, withdrawals, deposits and moved all are + 6
this causes the mysql query’s that we do are all off and displayed on next day
Example:
$sql3 = "SELECT COUNT(*) FROM $Table WHERE DATE(time)>='$fromDate' AND DATE(time)<='$endDate' AND location='$location' AND account='$account' ";
fromDate would be formatted like this 2019-5-02 same for endDate