time without seconds
| From: | Lisi | Date: | Tue, 17 Jun 2003 11:16:14 +0000 |
| Subject: | time without seconds | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28671@lists.php.net to get a copy of this message | ||
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?
2) Is there a way to store this without the seconds in MySQL?
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?
Thanks,
-Lisi