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

[Bryan Cantwell]

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

--


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org