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 trialMagnus Rydberg
4,683 PointsWhy do we use quotes for the Date datatype in SQL?
I am curious about the Date datatype in and why it needs quotes in SQL. If enter a date where year month and day are separated with a hyphen I guess the entry could be read as one single block of information. With quotes the date looks as though it is a string.
1 Answer
Steven Parker
231,184 PointsBut without quotes it looks like math. 2016-02-28 would become 1986!
So by using strings, and having dates implicitly convert from strings, you get to represent dates in a readable form. In fact, there are optional methods you can use to convert to/from a wide variety of (string) formats.
There actually is a numeric date format, but it's one really big number and not very convenient to use.
Magnus Rydberg
4,683 PointsMagnus Rydberg
4,683 PointsHello Steven and thanks for your reply.
That makes sense. So without quotes 2016-02-28 would be interpreted as a calculation. The quotes protects that from happening. The string itself can, depending on the datatype defined for the column, then be converted to a date.