Extract day of year from date postgresql July 8, 2019 16 32 64 128 Postgresql extract day of year from date Extract day of week from date postgresql Postgres extract day of year