You could use: CONCAT(DATE_FORMAT(FROM_UNIXTIME(1298999201),'%Y-%m-%d'),' 12:00:00')
JW On Tue, Mar 1, 2011 at 11:58 AM, Bryan Cantwell <bcantw...@firescope.com>wrote: > It was of course a typo, and even with the correct number isn't the answer > > > On 03/01/2011 11:47 AM, Claudio Nanni wrote: > >> >> You can start by using 60*60*24=86400 >> ;) >> >> On Mar 1, 2011 6:17 PM, "Bryan Cantwell" <bcantw...@firescope.com<mailto: >> bcantw...@firescope.com>> wrote: >> > 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=claudio.na...@gmail.com >> > >> > > > -- ----------------------------- Johnny Withers 601.209.4985 joh...@pixelated.net