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

2011-03-01 Thread Joerg Bruehe
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

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

2011-03-01 Thread 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/m

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

2011-03-01 Thread Bryan Cantwell
SELECT unix_timestamp() + 86400 + (unix_timestamp() % 86400); currently gives me 6:39 AM tomorrow SELECT UNIX_TIMESTAMP(DATE(FROM_UNIXTIME(1299003702))); actually gives me what I want, but seems really stupid way of getting something that is probably very simple On 03/01/2011 12:03 P

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

2011-03-01 Thread Johnny Withers
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 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

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

2011-03-01 Thread Bryan Cantwell
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" > wrote: > I'd asked before how to convert a unix timestamp

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

2011-03-01 Thread Claudio Nanni
You can start by using 60*60*24=86400 ;) On Mar 1, 2011 6:17 PM, "Bryan Cantwell" 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 > >

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

2011-03-01 Thread Bryan Cantwell
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