Convert date to day of year in Postgres

Question

How can I convert a column with a date e.g. '2012-08-03' to the day of year in Postgres?

Answer 1

Use the extract function:

select extract(doy from the_date_column)
from the_table