Dates in SQL

SQL date format is YYYY-MM-DD HH:MM: SS Dates can be in different formats because: Data manipulation in Excel MM/DD/YYYY Data was manually entered Data uses text to record months Functions SELECT DATE_TRUNC('day', date), SUM(total) FROM supermar...