<?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
