List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:February 24 2011 4:55pm
Subject:Re: Get date from unix_timestamp only up to the hour
View as plain text  
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
<bcantwell@stripped> wrote:
> 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=1
>
>



-- 
 - michael dykman
 - mdykman@stripped

 May the Source be with you.
Thread
Get date from unix_timestamp only up to the hourBryan Cantwell24 Feb
  • Re: Get date from unix_timestamp only up to the hourNathan Sullivan24 Feb
    • Re: Get date from unix_timestamp only up to the hourBryan Cantwell24 Feb
    • Re: Get date from unix_timestamp only up to the hourPintér Tibor24 Feb
  • Re: Get date from unix_timestamp only up to the hourMichael Dykman24 Feb
  • Re: Get date from unix_timestamp only up to the hourPintér Tibor24 Feb