Bryan Cantwell Convert unix time to 12:00 AM of that same day
Mar 01, 2011; 11:17
Bryan Cantwell
Convert unix time to 12:00 AM of that same day
I'd asked before how to convert a unix timestamp to the hour that it is in (and got the perfect answer) : 1298999201 = 3/1/2011 11:06:41 AM (1298999201 - (1298999201 % 3600)) = 3/1/2011 11:00:00 AM
Now getting the timestamp converted to midnight of that same day isn't as simple as: 1298999201 - (1298999201 % 85400) That just gives me a unix time from yesterday...
How can I convert 1298999201 (3/1/2011 11:06:41 AM) to 1298959200 (3/1/2011 12:00:00 AM)?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com
Mar 01
Claudio Nanni Re: Convert unix time to 12:00 AM of that same day
Mar 01, 2011; 18:47
Claudio Nanni
Re: Convert unix time to 12:00 AM of that same day
Mar 01
Johnny Withers Re: Convert unix time to 12:00 AM of that same day
Mar 01, 2011; 12:04
Johnny Withers
Re: Convert unix time to 12:00 AM of that same day
Mar 01
Joerg Bruehe Re: Convert unix time to 12:00 AM of that same day
Mar 01, 2011; 23:18
Joerg Bruehe
Re: Convert unix time to 12:00 AM of that same day
Mar 01
Bryan Cantwell Re: Convert unix time to 12:00 AM of that same day
Mar 01, 2011; 11:58
Bryan Cantwell
Re: Convert unix time to 12:00 AM of that same day
Mar 01
Bryan Cantwell Re: Convert unix time to 12:00 AM of that same day
Mar 01, 2011; 12:24
Bryan Cantwell
Re: Convert unix time to 12:00 AM of that same day
Mar 01
Bryan Cantwell Re: Convert unix time to 12:00 AM of that same day
Mar 01, 2011; 12:35
Bryan Cantwell
Re: Convert unix time to 12:00 AM of that same day
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!