2013-02-27 is the current standard, but more so as a result of "this is how we've done things" and not "this is the best way to do it". The hyphens make the notation ambiguous with substraction, therefore in programming languages dates are quoted and represented as strings, which in turn get passed to a parsing function.
- to_date('2022-03-27')
- datetime.strptime("2022-03-27", "%Y-%m-%d")
The obvious alternative is to use an unambigous notation from the list such as dot notation. 2022.03.27 doesn't collide with floating point number notation, nor with ipv4 notation, nor any arithmetic operation and thus can be used to represent dates in programming languages directly - without quotation and without the need to stringly type them.It's one of those many examples where "best practices" really only mean "current common practices".