search

TeMPOraL / cl-sqlite

Common Lisp binding for SQLite
http://common-lisp.net/project/cl-sqlite/
72 stars 27 forks source link

Wrong type returned on datetime. #20

Open spapas opened 1 month ago

spapas commented 1 month ago

Hello, I've got a table with a "created_on" datetime NOT NULL column. When I read it I get:

(ql:quickload 'sqlite)
(defvar *db* (sqlite:connect "db.sqlite3"))
(format t "~A" (type-of (sqlite:execute-single *db* "select created_on from apps_app")))

=> (SIMPLE-ARRAY CHARACTER (26))

It returns a string instead of a temporal type!

Any idea why this library doesn't return the correct type for the column?