round(seconds / 3600)
e.g.
ROUND(TIME_TO_SEC('00:39:38')/3600) ;
-John C.
On Tue, Apr 29, 2008 at 1:58 PM, Allen Shaw <[EMAIL PROTECTED]> wrote:
> Hi Gang,
>
> Anyone have a handy way to round time values to the nearest hour?
> I've got time values stored in the database (MySQL) and often need to group
> them by the hour (e.g., times between 09:30 and 10:29 get grouped under
> 10:00). Up to now I've been splitting on the colon and figuring it out
> based on the separate hour and minute values, but I thought there might be a
> better way...
>
> Thanks,
> Allen
>
> --
> Allen Shaw
> slidePresenter (http://slides.sourceforge.net)
>
> _______________________________________________
> New York PHP Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> NYPHPCon 2006 Presentations Online
> http://www.nyphpcon.com
>
> Show Your Participation in New York PHP
> http://www.nyphp.org/show_participation.php
>
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
