> For the complete documentation index, see [llms.txt](https://suporte-conttrade.gitbook.io/utilidades/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://suporte-conttrade.gitbook.io/utilidades/postgres-sql/ajustando-o-fuso-horario-do-banco-de-dados.md).

# Ajustando o Fuso Horario do banco de dados

```
--Check if you have the timezone set
SHOW TIMEZONE;

-- Ver a hora agora
select * from now ();

--If not set the timezone
SET TIMEZONE='America/Manaus';
--alter database  "dbCONTTRADE" set timezone to  'America/Manaus'


--
SELECT
     *
FROM pg_timezone_names
where utc_offset = '-04:00:00'

 

```