Hi!
I was just looking at this code yesterday, and I believe I have one of the
fixes in my tree to be pushed.
One thing about fixing datetime that I am worried about is the 000-00-00(...)
issue. I am wondering how many people rely on being able to use that instead of
NULL.
Cheers,
-Brian
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
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
