Re: date with month and year

On Thu, May 21, 2015 at 12:01 PM, Daniel Torres <nobeeakon(at)gmail(dot)com> wrote:

> I everybody, I'm new in the Postgresql world, and have an easy question:
> Is it possible to have date type data that only contain month and year?,
> how can I obtain that from a timestamp (without time zone) column?
>
> I've made this, but I think the result is a text, not a date
>
> select extract (Year from '2001-05-01 20:21:00'::TIMESTAMP WITHOUT TIME
> ZONE)||'-'|| extract(Month from '2001-05-01 20:21:00'::TIMESTAMP WITHOUT
> TIME ZONE);
>
>
>
> Any help is welcome, thanks
>
> Daniel
>
>
​I don't think so. Mainly because a date, at least in PostgreSQL, is by
definition a month, day, and year. You could just arbitrarily set the day
to "01" because every month starts with day 1, I guess.​ Perhaps if you
said what you want to do with this type of date field? Of course, if you
really wanted to, you could create your own data type and conversions. But
that still wouldn't be a "date", exactly.

--
My sister opened a computer store in Hawaii. She sells C shells down by the
seashore.

If someone tell you that nothing is impossible:
Ask him to dribble a football.

He's about as useful as a wax frying pan.

10 to the 12th power microphones = 1 Megaphone

Maranatha! <><
John McKown