CONVERT_TZ returning NULL

Hi

In one of our projects, I wanted to do timezone conversion from server
timezone to user time zone. I planned to use convert_tz function but
its not working on Google cloud sql.

I tried - select convert_tz(now(), 'UTC', 'US/Eastern') which returns
NULL

The timezone tables also return nothing - select * from time_zone;

I guess they are not populated. Can someone suggest how to do timezone
conversion on Google Cloud sql?

Thanks in advance.

- Naresh

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.