PostgreSQL/Date Timezone/extract

extract(MONTH FROM now())

postgres=#
postgres=# SELECT extract(MONTH FROM now());
 date_part
-----------
        10
(1 row)
postgres=#