ValueError: Couldn't parse datetime string '1383102430626' - value is not a string. about dataset HOT 6 CLOSED

Hm, thats an interesting error. Is the relevant database something that you could share to help me reproduce it?

from dataset.

https://www.dropbox.com/s/bdlcbs726vor6qg/ghost.db

from dataset.

I've done some analysis on the issue, what happens (From what I can tell) is that because the column is a DATETIME column SQLAlchemy treats it like one (And try to parse it as a regular date/time). However as can be seen in section 2.2 here DATETIME is actually a numeric in SQLite.

SQLAlchemy also has a section about date/time related types in SQLite here

from dataset.

Here's a gist containing minimal code to reproduce the issue, without even involving dataset

https://gist.github.com/3onyc/7469546

from dataset.

zzzeek suggested using a custom handler for datetime types, sounds like we'd need a special handler for an SQLite DB with datetime fields.

Example: https://gist.github.com/zzzeek/7470863
Thread: https://twitter.com/zzzeek/status/401039797097353216

from dataset.

Is this something we want to fix in dataset, or something people should implement a fix for themselves?

This considering that SQLite technically doesn't have a datetime type.

from dataset.