Mega Code Archive

 

Categories / PostgreSQL / Date Timezone

 

Extract(MONTH FROM now())

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