Luuk wrote: >sqlite> .mode column >sqlite> .headers on >sqlite> select 1 as X,date() as d union all select 2,date() union all >select 3,datetime(); >X d >---------- ---------- >1 2018-12-25 >2 2018-12-25 >3 2018-12-25
The value is longer than the column with (which is probably based on the values in the first line). Try ".width 10 20". Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users