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