List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:March 1 2011 5:47pm
Subject:Re: Convert unix time to 12:00 AM of that same day
View as plain text  
You can start by using 60*60*24=86400
;)
On Mar 1, 2011 6:17 PM, "Bryan Cantwell" <bcantwell@stripped> wrote:
> I'd asked before how to convert a unix timestamp to the hour that it is
> in (and got the perfect answer) :
> 1298999201 = 3/1/2011 11:06:41 AM
> (1298999201 - (1298999201 % 3600)) = 3/1/2011 11:00:00 AM
>
> Now getting the timestamp converted to midnight of that same day isn't
> as simple as:
> 1298999201 - (1298999201 % 85400)
> That just gives me a unix time from yesterday...
>
> How can I convert 1298999201 (3/1/2011 11:06:41 AM) to 1298959200
> (3/1/2011 12:00:00 AM)?
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>

Thread
Convert unix time to 12:00 AM of that same dayBryan Cantwell1 Mar
  • Re: Convert unix time to 12:00 AM of that same dayClaudio Nanni1 Mar
    • Re: Convert unix time to 12:00 AM of that same dayBryan Cantwell1 Mar
      • Re: Convert unix time to 12:00 AM of that same dayJohnny Withers1 Mar
Re: Convert unix time to 12:00 AM of that same dayBryan Cantwell1 Mar
Re: Convert unix time to 12:00 AM of that same dayBryan Cantwell1 Mar
  • Re: Convert unix time to 12:00 AM of that same dayJoerg Bruehe1 Mar