Data Type to represent a year/month value

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Data Type to represent a year/month value
Date: 2002-08-29 11:25:11
Message-ID: 3D6E0497.2040006@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

There doesn't seem to be a Date format that I can use. If possible I'd
like to use a built-in data type that would allow for comparisons and
maybe even arithmetic.

Jc

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-08-29 11:32:01 Re: date_part???
Previous Message Oleg Bartunov 2002-08-29 11:24:14 Re: Naming-scheme for db-files