Question: what is the difference between time and date?
Answer: 3 Answers. DATE: It is used for values with a date part but no time part. MySQL retrieves and displays DATE values in YYYY-MM-DD format. ... TIME: Its values are in HH:MM:SS format (or HHH:MM:SS format for large hours values).