List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:March 1 2011 6:04pm
Subject:Re: Convert unix time to 12:00 AM of that same day
View as plain text  
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 <bcantwell@stripped>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" <bcantwell@stripped<mailto:
>> bcantwell@stripped>> 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=1
>> >
>>
>
>
>


-- 
-----------------------------
Johnny Withers
601.209.4985
johnny@stripped

Thread
Convert unix time to 12:00 AM of that same dayBryan Cantwell1 Mar
  • Re: Convert unix time to 12:00 AM of that same dayClaudio Nanni1 Mar
    • Re: Convert unix time to 12:00 AM of that same dayBryan Cantwell1 Mar
      • Re: Convert unix time to 12:00 AM of that same dayJohnny Withers1 Mar
Re: Convert unix time to 12:00 AM of that same dayBryan Cantwell1 Mar
Re: Convert unix time to 12:00 AM of that same dayBryan Cantwell1 Mar
  • Re: Convert unix time to 12:00 AM of that same dayJoerg Bruehe1 Mar