Hello all,
I'm new to sqlite3. I have data in a Oracle table with one column being a date
type. Now, I've exported this table into a sql file with insert statements.
Then, I ran the .read command in sqlite3 to read in the sql statements.
sqlite doesn't support the TO_Date function.
How do I get around this? My sql file is large, i.e > 8000 rows.
Is there maybe a way to define this function internally?
I'm using TOAD to create the sql file from Oracle.
Your inputs appreciated!!
Thanks.
ps my table schema below:
CREATE TABLE NBIAUTO
(
OPERATION VARCHAR2(50),
INTERFACE VARCHAR2(50),
OCRELEASE VARCHAR2(8),
RUNDATE DATE,
PRODUCTS VARCHAR2(255),
SERVER VARCHAR2(50),
REQUEST VARCHAR2(4000),
REQUEST2 VARCHAR2(4000),
RESPONSE CLOB
)
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
