Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases Reporting with SQL Date and Time Functions Calculating Dates

Posted by Mark Chesney
Mark Chesney
11,747 Points

february 31

Just an observation: I notice SQLite allows us to run February 31 without error catching:

SELECT DATE("2016-02-32");

1 Answer

Marcos Treviño Rodriguez
Marcos Treviño Rodriguez
5,711 Points
Marcos Treviño Rodriguez
Marcos Treviño Rodriguez
5,711 Points

I think it will allow you because it was a manual input but when trying to retrive data, is going to be blank. I'm going to guess that maybe if you add more months as well it will be possible right?