Hello,
I am trying to setup a range partitioned table using 5.5.27-MariaDB-log
MariaDB Server using a timestamp field. According to the documents, I should be
able to use unix_timestamp(ts) as my partitioning function (
http://dev.mysql.com/doc/refman/5.5/en/partitioning-range.html ) . I find,
however, that it is not possible to use unix_timestamp using mariadb because
with mariadb the unix_timestamp function returns an floating point value:
mariadb> select unix_timestamp('2012-12-01');
+------------------------------+
| unix_timestamp('2012-12-01') |
+------------------------------+
| 1354320000.000000 |
+------------------------------+
1 row in set (0.00 sec)
However the MySQL version of unix_timestamp returns an int value:
myqsl> select unix_timestamp('2012-12-01');
+------------------------------+
| unix_timestamp('2012-12-01') |
+------------------------------+
| 1354320000 |
+------------------------------+
1 row in set (0.06 sec)
How have people worked around this issue? What other ways can I partition by a
timestamp in MariaDB ?
Thanks,
-Said
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
