storing months in mysql 4

Hello, I'm using PHP 4 and MySQL 4. I want to store the month and year
as a single row but I am having difficulty figuring out the best data
type to use. I suppose I could use 'DATE' and then always have the day
value be equal fto 1, but I figure there's a more elegant approach. I
leave it to on e of you experts to recommend one.

Thanks in advance, - Dave

re: storing months in mysql 4

laredotorn...@zipmail.com wrote:[color=blue]
>
> I'm using PHP 4 and MySQL 4. I want to store the month and
> year as a single row but I am having difficulty figuring out
> the best data type to use.[/color]

The best for WHAT? How do you intend to use the data? What
typical computations will be performed on it? What will it
be routinely compared to?
[color=blue]
> I suppose I could use 'DATE' and then always have the day
> value be equal fto 1, but I figure there's a more elegant
> approach.[/color]

Again, depends on how you are going to use the data. Maybe
for your purposes it makes more sense to set the date to the
last day of the month...

Cheers,
NC

re: storing months in mysql 4

On 29 Apr 2005 06:16:41 -0700, laredotornado@zipmail.com wrote:
[color=blue]
>Hello, I'm using PHP 4 and MySQL 4. I want to store the month and year
>as a single row but I am having difficulty figuring out the best data
>type to use. I suppose I could use 'DATE' and then always have the day
>value be equal fto 1, but I figure there's a more elegant approach. I
>leave it to on e of you experts to recommend one.[/color]

In the past, I've stored the month as an int representing "months
since Jan 2000", or some other "beginning of time" date.

HTH.

--
David ( @priz.co.uk )