Re: time without seconds

Lisi wrote:

If I have a time stored in MySQL, and I only need the hour and minutes without seconds: 1) Can I crop this in PHP after retrieving it?

Sure, just chop off the last : and what's after it if in HH:MM:SS format, or the last two numbers if in HHMMSS format.

2) Is there a way to store this without the seconds in MySQL?

Not really. You could use DATE_FORMAT or TIME_FORMAT to format the date/time without the seconds, though.

Same goes for storing a date without the year. I could use a regular char field, but I want to be able to retrieve a row that corresponds to the current month and day, currently I am doing this with $month = date("n"); $day = date("d"); $query = "SELECT ... WHERE MONTH(date) = $month AND DAYOFMONTH = $day"; Is there a better way to do this without storing unnecessary data?

I don't think there's any way to not store the year. Just ignore it like you're doing. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ PHP|Architect: A magazine for PHP Professionals – www.phparch.com