Get date from unix_timestamp only up to the hour

[Bryan Cantwell]

How would I go about modifying a unix timestamp to actually represent 
the 'top of the hour' that it represents?
For instance:
1296158500 = 1/27/2011 2:01:40 PM
That is in the 2:00 pm hour, how can I find that out and modify it to 
1296158400 which = 1/27/2011 2:00:00 PM?




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org