1 year ago
#351010
James Radcliff
Why is my professor saying storing Dates as Dates are incorrect?(Varchar)
I am taking a course at a public uni in the US. Currently, we are learning databases(mySQL) where we are storing dates in ISO format: (2020-01-29), I was originally storing them as Dates, because I assumed its a Date, so it should obviously be stored as such. However, I have been informed by the professor and multiple TAs that storing them as VARCHARs are better, as Dates are handled differently in different versions of mySQL, and that dates, when stores as dates, are not usually interoperable. I've obviously researched this topic online, and can't find any reason to store them as VARCHAR over date. Is my professor(and TAs) wrong, what would make them think this way? Or am I just being stubborn?
mysql
varchar
0 Answers
Your Answer