Sort by Date
Alright guys, what am I doing wrong here?
I have a CSV that I'm importing into a SQLite database. During the import, I'm changing the field type from TEXT to DATE. I've set the date_string_format to "mm/d/yyyy hh:mm:ss aa"
My data has dates in the format: "10/5/2018 10:01:00 AM" and "10/15/2018 10:01:00 AM"
When I sort, the 15 comes before the 5 - so it's obviously still sorting on the text rather than the date...
How do I get DataGrip to recognize that the data I'm importing is actually a date?
Please sign in to leave a comment.
Hi! You sort your result table, right? And it has DATE type, right?