Re: Data Type to represent a year/month value

From: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>
To: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Data Type to represent a year/month value
Date: 2002-09-05 12:47:29
Message-ID: 20020905124729.GA17658@nic.fr
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Aug 29, 2002 at 08:25:11PM +0900,
Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)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).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Markus Wollny 2002-09-05 13:41:54 Problem with restoring dump (may be tsearch-related)
Previous Message fpaul 2002-09-05 12:28:56 PostgreSQL vs MySQL : strange results on insertion