Re: Convert unix time to 12:00 AM of that same day

[Joerg Bruehe]

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