[eluser]jules123[/eluser]
I have CI working with Oracle, thanks to all the good info on this forum.
Now I have a problem with a specific query that tries to set a date field in Oracle.
Here is the general code in my helper function (using Active records) -
$CI = & get_instance();
$oradb = $CI->load->database('oradb', TRUE);
$data_arr = array('username'=> 'abc','data_updated' => date('d-M-Y'));
$oradb->insert('users', $data_arr);
Now the above works fine, but if I try to change the date('d-M-Y') to anything more granular which includes hr/sec/mins, then I get the following error:
ORA-01830: date format picture ends before converting entire input string.
So it looks like since Oracle DATE type uses 'd-M-Y' as the default format, that's all it will accept as a string representation for date field...Would like to know if anyone has any thoughts on how I can set the field with the full date-timestamp, not just 'd-M-Y'.
Thanks in advance!