I'm trying to convert mysql current timezone, to another one. But I'm getting Null as answer:
select *, CONVERT_TZ(NOW(),@@session.time_zone, 'America/Sao Paulo')
from historical_prices;
This is my query.
How can I fix this?
Asked
Active
Viewed 114 times
0
Filipe Ferminiano
- 8,373
- 25
- 104
- 174
-
have you checked this?looks like your problem. https://stackoverflow.com/questions/2523286/mysql-convert-tz – Atilla Arda Açıkgöz Jul 29 '17 at 22:07
-
Possible duplicate of [MySQL CONVERT\_TZ()](https://stackoverflow.com/questions/2523286/mysql-convert-tz) – Atilla Arda Açıkgöz Jul 29 '17 at 22:08