Dear Sir/Madam,

My database is located in US server with timezone GMT-8, my client is located in HK with timezone GMT+8, I setup the grid setting related to the field timestamp as below

$g->select_command = "SELECT recID, name, contact, email, gender, age, ticket, address, referrer, TIMESTAMP +INTERVAL 16 HOUR AS timestamp FROM quf_reg";

$col = array();
$col["name"] = 'timestamp';
$col["title"] = "Register Time";
$col["export"] = true;
$cols[] = $col;

The timestamp is correctly display in client's timezone, but when entering the time in filter, the rows are filtered according to the server's timezone.

How can I filter the result using client's timezone?

Best regards,

Kelvin.