On 12 Jan 2013, at 9:22pm, Ted Heng <[email protected]> wrote: > Here's another problem. I presumed the problem is with the dump value in > fraction instead of in the format 'YYYYMMDD ...', etc. Can I change the date > format of the dump?
SQLite doesn't have a date format. You can choose to store a date in various formats including text, real numbers and integers, with various interpretations for each. Fortunately, DATETIME2 is a SQL Server format, and you shouldn't much trouble interpreting these. I would import them into REAL fields (change the table definition line in your SQL text file) and later use SQL Server code to UPDATE using a 'cast()'. No idea what a SQL Server-only type is doing in a SQLite database. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
