Thank you all, the following N1QL works:
select str_to_tz(str_to_utc(SUBSTR("2017-05-02 17:20:07 UTC",0,19)), "Asia/Shanghai") || " CST"
Thank you all, the following N1QL works:
select str_to_tz(str_to_utc(SUBSTR("2017-05-02 17:20:07 UTC",0,19)), "Asia/Shanghai") || " CST"