How to write date without year?

Question

PostgreSQL

How to store date in database without year if possible? Or how to get all records from January 1st to January 31st for all years? Thank you.

Answer 1

A date can be stored using the date type (date only, no time) or a timestamp. Records for January can be selected by the appropriate condition using DATE_PART - DATE_PART('month' ...etc.