From: Michael Dykman Date: February 24 2011 4:55pm Subject: Re: Get date from unix_timestamp only up to the hour List-Archive: http://lists.mysql.com/mysql/224498 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable If the timestmp is in seconds, the result is simply mod(timestamp,3600) - michael dykman On Thu, Feb 24, 2011 at 11:41 AM, Bryan Cantwell wrote: > How would I go about modifying a unix timestamp to actually represent the > 'top of the hour' that it represents? > For instance: > 1296158500 =3D 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 =3D 1/27/2011 2:00:00 PM? > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail= .com > > --=20 =A0- michael dykman =A0- mdykman@stripped =A0May the Source be with you.