date with month and year
| От | Daniel Torres |
|---|---|
| Тема | date with month and year |
| Дата | |
| Msg-id | CAJGorGyMC0n5x9Zow+sn2Tc5z4STjPGyHHiBHaHqugx9FC0fCw@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: date with month and year
Re: date with month and year Re: date with month and year Re: date with month and year Re: date with month and year |
| Список | pgsql-general |
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 dateselect 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);
В списке pgsql-general по дате отправления: