Hi there,

I am very new to SQLite but like it sofar.
Run into something couldn’t find an answer may someone can put me in the right 
direction..

Have an application uses SQLite table with a column “Datum” defined as bigint.
I have an identical table with column “Datum” as DateTime “yyyy-mm-dd”

How can I convert this column -preferable in place- to bigint?

Some more info:

“2004-08-05” should be converted to “632272608000000000” .

Thank You,
in advence.
(Tibor)
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to