title: How to store a mix of partial dates in PostgreSQL, which format can be yyyy-mm-dd, yyyy-mm or yyyy?
body: <p>How should I store a date in PostgreSQL when I have a mix of <code>yyyy-mm-dd</code> format (e.g., 2000-12-31), <code>yyyy-mm</code> and <code>yyyy</code> ? Can I still use a <code>DATE</code> column ?</p>