From: | "Jeff Flowers" <duckfoo(at)fastmail(dot)fm> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Year Only Date Column |
Date: | 2004-11-23 15:21:04 |
Message-ID: | 1101223264.2680.209293607@webmail.messagingengine.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Tue, 23 Nov 2004 22:28:08 +0900, "Michael Glaesemann"
<grzm(at)myrealbox(dot)com> said:
>
> On Nov 23, 2004, at 10:16 PM, Jeff Flowers wrote:
>
> > 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.
>
> You could do that, or create a domain that would restrict the date to
> only be, say, CCYY-01-01, which would represent the year.
Since I will be using this column only for the sake of completeness, I
think that I will either use the numeric column (or perhaps a CHAR(4)
column).
Thanks,
--
Jeff Flowers
From | Date | Subject | |
---|---|---|---|
Next Message | George Weaver | 2004-11-23 16:13:36 | Re: xml2 compile error - work_mem undeclared |
Previous Message | Michael Glaesemann | 2004-11-23 13:28:08 | Re: Year Only Date Column |