List:General Discussion« Previous MessageNext Message »
From:Bryan Cantwell Date:March 1 2011 6:35pm
Subject:Re: Convert unix time to 12:00 AM of that same day
View as plain text  
That's closer:
SELECT
   UNIX_TIMESTAMP() + 86400 - (UNIX_TIMESTAMP() % 86400);
Gives me 6:00 PM today...

On 03/01/2011 12:32 PM, Singer X.J. Wang wrote:
> SELECT
>  unix_timestamp() + 86400 - (unix_timestamp() % 86400);

--
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