On 9/10/2019 7:05 AM, Keith Medcalf wrote:
select value,
        round((julianday(value) - julianday('00:00:00')) * 86400.0, 3)
   from test;

Another possibility: strftime('%s', '1970-01-01 ' || value)
--
Igor Tandetnik


_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to