UTCTime values inserted into SQLite Databases look like this
2014-11-30 05:15:25.395343 UTC

This does not conform to the specification of an SQLite Date Value:

TEXT as ISO8601 strings ("YYYY-MM-DD HH:MM:SS.SSS")

(from https://www.sqlite.org/datatype3.html)

and consequently, queries like the following produce no output:

> select date("2014-11-30 05:15:25.395343 UTC")

expected output:

> select date("2014-11-30 05:15:25")
2014-11-30