Year Only Date Column

From: "Jeff Flowers" <duckfoo(at)fastmail(dot)fm>
To: pgsql-novice(at)postgresql(dot)org
Subject: Year Only Date Column
Date: 2004-11-23 13:16:13
Message-ID: 1101215773.20912.209283327@webmail.messagingengine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I want to create a date column that contains only the year, such as
YYYY. Can this done in PostgreSQL? I didn't see this listed in the
handbook and right now, the only way I can see to do would be to create
a numeric data field with zero scale and a precision of four.

Thanks,

--
Jeff Flowers

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Glaesemann 2004-11-23 13:28:08 Re: Year Only Date Column
Previous Message Jeff Flowers 2004-11-22 22:55:09 Re: Using PostgreSQL As A Personal Database