Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 23 Nov 2004 08:16:13 -0500
- Message-id: <1101215773.20912.209283327@webmail.messagingengine.com> <text/plain>
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
- Follow-Ups:
- Re: Year Only Date Column
- From: Michael Glaesemann
- Re: Year Only Date Column
- Prev by Date: Re: Using PostgreSQL As A Personal Database
- Next by Date: Re: Year Only Date Column
- Previous by thread: postgis compile question
- Next by thread: Re: Year Only Date Column
- Indexes: