PostgreSQL/Date Timezone/extract

extract(MONTH FROM now())

   <source lang="sql">

postgres=# postgres=# SELECT extract(MONTH FROM now());

date_part

---

       10

(1 row) postgres=#

      </source>