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?

1 comment

Hi! You sort your result table, right? And it has DATE type, right?

 

0

Please sign in to leave a comment.