#5830: Oracle - Timestamp field datatype issue --------------------------+------------------------------------------------- Reporter: jaydipdave | Owner: phishy Type: Bug | Status: new Priority: High | Milestone: 1.2.x.x Component: Oracle | Version: RC2 Severity: Major | Keywords: Php_version: n/a | Cake_version: --------------------------+------------------------------------------------- Hi Folks,
I found one more issue with "timstamp" datatype of oracle. when i am using timestamp datatype for last_login field in oracle. The generated query tries to store the data inform of string! I have highlighted missing statment in dbo_oracle.php {{{ switch($column) { '''case 'timestamp': // MISSING STATEMENT''' case 'date': $data = date('Y-m-d H:i:s', strtotime($data)); $data = "TO_DATE('$data', 'YYYY-MM-DD HH24:MI:SS')"; break; case 'integer' : case 'float' : case null : if (is_numeric($data)) { break; } default: $data = str_replace("'", "''", $data); $data = "'$data'"; break; } }}} Have fun, Thank You, Jaydeep Dave -- Ticket URL: <https://trac.cakephp.org/ticket/5830> CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/> Cake is a rapid development framework for PHP which uses commonly known design patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC. Our primary goal is to provide a structured framework that enables PHP users at all levels to rapidly develop robust web applications, without any loss to flexibility. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "tickets cakephp" group. To post to this group, send email to tickets-cakephp@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/tickets-cakephp?hl=en -~----------~----~----~----~------~----~------~--~---