Sort by column of type datetime

Alecaddd / sequeler

SQL Client built in Vala

GNU General Public License v3.0

800 stars 66 forks source link

Sort by column of type datetime #182

Open g-shon opened 5 years ago

g-shon commented 5 years ago

When using the Data tab to view table data, you CANNOT sort column of data type DATETIME.

Alecaddd commented 5 years ago

Can you elaborate on this issue a bit more and provide some screenshot? What happens when you click on the datetime column? It simply doesn't sort the data or do you get an error?

wout commented 5 years ago

I am experiencing this issue as well.

Sorting ascending:

Sorting descending:

Alecaddd commented 5 years ago

Yes, this is an issue related to the way libGDA prints data and time stamps. I'm creating a workaround to sort via SQL query and not via Gtk.TreeView. A fix will come out shortly, sorry for the inconvenience.