I am working on my own independent project with SQLite. I am using the following code to find the max and min date from the table.
SELECT MAX(date_column), MIN(date_column)
The question I have is, the result does not come back accurately. For example, the true min date is June 2014. But the MIN date result come as January 2015.
What could be the problem here? The date column type was set up as “TEXT”. And it’s in the following format, “YYYY-MM-DD, HH:MM:SS”.
Thank you all!