Bug Report for https://neetcode.io/problems/sql-dates
1. Typo in the Explanation Section
Location: Question tab, first line of the explanation.
Current text: "It's common to record the data and / or time when something happens."
Should be: "It's common to record the date and / or time when something happens."
"data" should be "date".
2. Wording/Clarity Issue in the Note Section
Location: Question tab, Note at the bottom of the page.
Current text: "With the Postgres engine we are using, the DATE column stores a default time of 00:00:00 which cannot be changed."
Suggested clarification: The DATE type does not actually store 00:00:00 in the engine — the engine stores DATE strictly as YYYY-MM-DD. The 00:00:00 is added by the frontend/client when formatting the value for display. The current wording implies the engine stores a time component, which is misleading.
Bug Report for https://neetcode.io/problems/sql-dates
1. Typo in the Explanation Section
Location: Question tab, first line of the explanation.
Current text: "It's common to record the data and / or time when something happens."
Should be: "It's common to record the date and / or time when something happens."
"data" should be "date".
2. Wording/Clarity Issue in the Note Section
Location: Question tab, Note at the bottom of the page.
Current text: "With the Postgres engine we are using, the DATE column stores a default time of 00:00:00 which cannot be changed."
Suggested clarification: The DATE type does not actually store 00:00:00 in the engine — the engine stores DATE strictly as YYYY-MM-DD. The 00:00:00 is added by the frontend/client when formatting the value for display. The current wording implies the engine stores a time component, which is misleading.