This is part of the Semicolon&Sons Code Diary - consisting of lessons learned on the job. You're in the data category.
Last Updated: 2024-11-21
When in doubt, always store and transfer dates in ISO 8601, the most popular standard.
Some reasons why?
YYYY-MM-DDTHH:MI:SS.MSSZ - e.g 2012-04-23T18:25:43.511Z
e.g. you get date time validations working without any messing around