This guide walks you through the most commonly used MySQL date functions—CURDATE, NOW, DATE_FORMAT, DATEDIFF, DATE_ADD, DATE_SUB, and DATE—explaining their purpose, syntax, and example results so you can handle date and time data efficiently in your databases.
The article recounts a developer's experience with FastJson, detailing a date‑format configuration bug caused by an outdated library version, a $ref circular‑reference serialization issue, the debugging steps taken, and broader observations about FastJson's maintenance and feature defaults.
The article recounts a senior architect's investigation into FastJson's date formatting bug and circular reference handling, detailing version mismatches, GitHub issue tracking, feature flag usage, and lessons for backend developers on avoiding hidden serialization pitfalls.
This guide explains how MySQL handles string‑date conversions, shows when to use date_format for query conditions, warns about performance impacts, demonstrates converting query results with str_to_date, and clarifies the meaning of common format placeholders.
The article outlines key challenges in distributed API design—including date formatting, decimal precision, response structures, idempotency, security, and naming consistency—and provides practical recommendations to improve usability, scalability, and maintainability across backend services.
