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