maria-discuss team mailing list archive

[Said Ramirez <sramirez@xxxxxxxxxxxx>]

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