NOW(tz=?) - what is a valid "tz"?

Ask for Help
1

Hi

I’m having problems using NOW() with the Brazil time zone. There is no reference at the “Grist Help Center” for what is a valid “tz” as a parameter for NOW(). I’ve tried “BR” and “-3” but neither works.

Any suggestion?

Eduardo

2

If you set a column to type “DateTime”, the dropdown for “TIMEZONE” has the valid values, minus the "(GMT +/-XX:XX) " prefix. So NOW(tz='Brazil/Acre') works. I agree that this is very much not obvious.

3

You can get a full list of valid timezones with this code snippet:

import pytz
pytz.all_timezones

For Brazil, I see those options:

 Brazil/Acre,
 Brazil/DeNoronha,
 Brazil/East,
 Brazil/West
4

Thank you! That will help!

Cheers,

Eduardo