[Squirrel-sql-users] SQLite: Objects/Data tab vs SQL query results tab

[info <in...@dr...>]

Hello, everyone:

With SQLite aliases, the Objects/Data tab displays <Error> for certain 
columns, but the SQL query results tab displays the data from them, in 
ISO format if I remember correctly.
The particular case that I created recently is for a table with a column 
that was created using DATETIME for its data type. This is probably a 
copy/paste error because SQLite officially does not have such a date 
type, but it works for some reason. All of the viewers known to me 
display it as DATETIME, ADO.NET and JDBC display the values reasonably, 
and since its value is already displayed in the query results, it 
probably makes sense to synchronize the Data tab with the code that does.

Regards
Al