What problem does it solve? Writing correct date and time SQL in MariaDB is error-prone: NOW() versus SYSDATE() semantics, INTERVAL syntax requirements, week-numbering modes, time-zone table dependencies, and argument-order traps like TIMESTAMPDIFF cause subtle bugs. This Skill provides a complete catalog of all 64 built-in MariaDB date/time functions plus a curated list of the mistakes LLMs and developers most often make. ## Core Features & Use Cases - Complete function catalog: Signatures and one-line semantics for every date/time function, covering current time, arithmetic, differences, extraction, parsing/formatting, Unix time, time-zone conversion, and Oracle-compatible helpers. - Pitfall correction table: Maps common wrong assumptions (e.g., DATE_ADD(d, 7), DAYOFWEEK vs WEEKDAY indexing, CONVERT_TZ returning NULL) to the correct MariaDB form. - Version awareness: Functions annotated with the MariaDB version that introduced them, defaulting to 11.8 LTS context. - Use Case: When asked to compute the number of months between two timestamps, the Skill ensures you write TIMESTAMPDIFF(MONTH, start, end) with the unit first rather than guessing the argument order. ## Quick Start Ask the AI to write a MariaDB query that converts a UTC timestamp to Europe/Berlin and formats it, and it will apply the correct CONVERT_TZ and DATE_FORMAT usage from this Skill.
