Postgres Pro
Downloads
Home   >   mailing lists

Year Only Date Column - Mailing list pgsql-novice

From Jeff Flowers
Subject Year Only Date Column
Date
Msg-id 1101215773.20912.209283327@webmail.messagingengine.com
Whole thread Raw
Responses Re: Year Only Date Column
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: "Jeff Flowers"
Date:
Subject: Re: Using PostgreSQL As A Personal Database
Next
From: Michael Glaesemann
Date:
Subject: Re: Year Only Date Column