Re: Data Type to represent a year/month value

Поиск
Список
Период
Сортировка
От Stephane Bortzmeyer
Тема Re: Data Type to represent a year/month value
Дата
Msg-id 20020905124729.GA17658@nic.fr
обсуждение исходный текст
Ответ на Data Type to represent a year/month value  (Jean-Christian Imbeault <jc@mega-bucks.co.jp>)
Список pgsql-general
On Thu, Aug 29, 2002 at 08:25:11PM +0900,
 Jean-Christian Imbeault <jc@mega-bucks.co.jp> wrote
 a message of 14 lines which said:

> What would be the best data type to use to represent values of the kind
> year/month? I.e. 2002/10, 2003/01

I would use a regular time stamp with a convention to set the day and
the time to zero (may be with a trigger to ensure that the convention
is respected).


В списке pgsql-general по дате отправления:

Предыдущее
От: "Nigel J. Andrews"
Дата:
Сообщение: Re: could not login as a root
Следующее
От: "Markus Wollny"
Дата:
Сообщение: Problem with restoring dump (may be tsearch-related)