Posted by Philip Hallstrom on 07/22/05 00:46

> Hi all,
> I need to manage some records with dates. mmddyyyy
>
> I'm putting select options breaking the three up in numeric pull
> downs. no problem gathering and storing the data in my mysql db as
> integers then posting them for existing records etc. i know their is a
> datetime datatype but it doesnt seem easier to use this data type than
> using integers...any tips or routines for handling this?

It is much much easier to use at least the DATE type in your database.

What if, six months from now you want to select all records that occured
on even numbered Tuesdays?

How would you do that if all you have is integers?

I suppose you could look at every single row and do the math in PHP, but
that's going to be a pain and won't scale very well...

Good luck!

[Back to original message]