I wonder how long it will be before someone complains that this QotD is misleading and incorrect since the question specifies "(yyyy/mm/dd)" format and the answers are all in YYYY-MM-DD format?
:laugh:
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi