This code bellow working version on 9.7
AND t1.STARTTIMESTAMP BETWEEN CONVERT_TZ(
'2017-07-06 10:08',
'+07:00',
'+00:00'
)
AND CONVERT_TZ(
'2017-07-07 10:08',
'+07:00',
'+00:00'
)
after the upgrade all code behind : will striped
AND (
`t1`.`STARTTIMESTAMP` BETWEEN CONVERT_TZ(
'2017-07-06 10',
'+07',
'+00'
)
AND CONVERT_TZ(
'2017-07-07 10',
'+07',
'+00'
)
)
this query bellow also not working tested in Build 29111
SELECT
ID,
convert_tz(DT, '+00:00', '+07:00') AS DT,
SYS,
GRP,
IN,
OUT,
OUTOK,
INOK
FROM SYSSYS