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.bru...@oracle.com 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org