Thread: Data Type to represent a year/month value

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

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).