I've a table with a column that was created with type "date". Later the type was changed to "datetime".
desc shows column type as datetime, but if I find the column type from INFORMATION_SCHEMA.COLUMNS then the datatype is shown as "date". Here is the query
SELECT column_name, data_type, column_type
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_name = '<My Table Name>'
AND column_name = '<Column Name>'
This shows data_type and column_type as "date"
My question is why does "desc " shows different datatype than the one displayed by the query.