I'm trying to insert data in my Oracle database with the query builder but I'm having an issue with the date field...
Normally, the syntax is like this: INSERT INTO tablename VALUES (to_date('2014-04-20','YYYY-MM-DD')). The Fuel query builder sees it as a string so the query looks like this: INSERT INTO tablename VALUES ('to_date(''2014-04-20'',''YYYY-MM-DD'')') and of course it fails.
So my question is: is there a way to handle dates with the query builder?
Donate
