On 02/24/2011 05:56 PM, Nathan Sullivan wrote: > Bryan, > > Maybe something like this would work? > > select 1296158500 - (1296158500 % 3600)
ah, yes, even this one: mysql> select now() - interval (unix_timestamp() % 3600) second; +---------------------------------------------------+ | now() - interval (unix_timestamp() % 3600) second | +---------------------------------------------------+ | 2011-02-24 18:00:00 | +---------------------------------------------------+ 1 row in set (0.00 sec) t -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org