Hello! On Friday 27 February 2009 01:17:51 D. Richard Hipp wrote: > > Then, I ran the .read command in sqlite3 to read in the sql > > statements. > > sqlite doesn't support the TO_Date function. > > Please send me an example of the TOAD-generated INSERT statement that > includes a TO_Date function.
I did use this functions: #Access now() proc now {} {clock format [clock seconds] -format "%Y-%m-%d %H:%M:%S" -gmt 0}; #Read Oracle date format proc oradate {date} {clock format [clock scan $date] -format "%Y-%m-%d %H:%M: %S" -gmt 0}; May be possible to add this to SQLite corefuncs? Best regards. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users