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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users