List:General Discussion« Previous MessageNext Message »
From:Joerg Bruehe Date:March 1 2011 10:18pm
Subject:Re: Convert unix time to 12:00 AM of that same day
View as plain text  
Hi Bryan, all!


Bryan Cantwell wrote:
> That's closer:
> SELECT
>   UNIX_TIMESTAMP() + 86400 - (UNIX_TIMESTAMP() % 86400);
> Gives me 6:00 PM today...

The Unix timestamp is UTC-based (old name: GMT).
You don't write which timezone you are using, but your notation "6:00
PM" makes me assume you are US-based.

Is it 6:00 PM in your timezone at UTC midnight?


Joerg

-- 
Joerg Bruehe,  MySQL Build Team,  joerg.bruehe@stripped
ORACLE Deutschland B.V. & Co. KG,   Komturstrasse 18a,   D-12099 Berlin
Geschaeftsfuehrer: Juergen Kunz, Marcel v.d. Molen, Alexander v.d. Ven
Amtsgericht Muenchen: HRA 95603
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