-2

Please correct me but I've located a small error on the Mariadb documentation on https://mariadb.com/kb/en/range-partitioning-type/

The second example under Use cases has a superfluous UNIX_TIMESTAMP in the PARTION BY RANGE line. As the column timestamp already is a unix timestamp UNIX_TIMESTAMP(timestamp) will not work, will it? The line should read

 PARTITION BY RANGE( TimeStamp )

Not sure how to get in touch with the ppl. that write the manual.

3
  • You could try the "contact" link at the bottom of that page. Apr 22 '20 at 13:39
  • 1
    I’m voting to close this question because it's not a question that can be answered. Apr 22 '20 at 13:39
  • It could be and is answered.
    – theking2
    Apr 30 '20 at 10:58
2

No, you are wrong. Check the documentation: https://mariadb.com/kb/en/timestamp/

This is a TIMESTAMP:

A timestamp in the format YYYY-MM-DD HH:MM:SS.ffffff.

This is UNIX_TIMESTAMP:

1374490205

2
  • Yeah, the column names in those examples are confusing.
    – Rick James
    Apr 23 '20 at 1:02
  • My mistake, Thanks for checking on me, Swisstone.
    – theking2
    Apr 29 '20 at 16:14

Not the answer you're looking for? Browse other questions tagged or ask your own question.