Hi Brian,
Would you file a bug on this so we can track this issue?
Thanks, Lee
On Jun 10, 2010, at 10:01 AM, Brian Moon wrote:
> <?php
>
> $microtime = 1272945599.9125;
>
> echo date("r", $microtime);
>
> ?>
>
> Gives a sane response IMO.
>
> Mon, 03 May 2010 23:59:59 -0400
>
>
> MySQL: (Eastern)
>
> mysql> select from_unixtime(1272945599.90000),
> from_unixtime(1272945599), from_unixtime("1272945599.90000")\G
> *************************** 1. row ***************************
> from_unixtime(1272945599.90000): 2010-05-04 00:00:00
> from_unixtime(1272945599): 2010-05-03 23:59:59
> from_unixtime("1272945599.90000"): 2010-05-03 23:59:59
> 1 row in set, 1 warning (0.01 sec)
>
>
> Drizzle Version: '2010.03.1347': (Central)
>
> mysql> select from_unixtime(1272945599.90000),
> from_unixtime(1272945599), from_unixtime("1272945599.90000")\G
> *************************** 1. row ***************************
> from_unixtime(1272945599.90000): 2010-05-03 23:00:00
> from_unixtime(1272945599): 2010-05-03 22:59:59
> from_unixtime("1272945599.90000"): 2010-05-03 22:59:59
> 1 row in set, 1 warning (0.08 sec)
>
> Can we fix this in Drizzle? I have no hope for MySQL.
>
> --
>
> Brian.
> --------
> http://brian.moonspot.net/
>
> _______________________________________________
> Mailing list: https://launchpad.net/~drizzle-discuss
> Post to : [email protected]
> Unsubscribe : https://launchpad.net/~drizzle-discuss
> More help : https://help.launchpad.net/ListHelp
Confidentiality Notice: This e-mail message (including any attached or
embedded documents) is intended for the exclusive and confidential use of the
individual or entity to which this message is addressed, and unless otherwise
expressly indicated, is confidential and privileged information of Rackspace.
Any dissemination, distribution or copying of the enclosed material is
prohibited.
If you receive this transmission in error, please notify us immediately by
e-mail
at [email protected], and delete the original message.
Your cooperation is appreciated.
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
