this query doesn't work in oracle

SELECT DISTINCT m_bug_tbl.id as id, FROM m_project_tbl, m_bug_tbl
WHERE m_project_tbl.enabled = 1 AND m_project_tbl.id = m_bug_tbl.project_id AND m_bug_tbl.date_submitted BETWEEN '2006-2-1 00:00:00' AND '2006-4-12 23:59:59'

first, I've added a new function in database_api.php

function db_prepare_date( $p_date)
{
$t_db_type = config_get( 'db_type' );

    switch( $t_db_type ) {
        case 'mssql':
        case 'odbc_mssql':
        case 'mysql':
        case 'mysqli':
        case 'postgres':
        case 'postgres64':
        case 'postgres7':
        case 'pgsql':
        return '$p_date';
        case 'oci8':
        return "TO_TIMESTAMP('$p_date','YYYY-MM-DD HH24:MI:SS')";
}
}

then I've modified at the line 520 in filter_api.php
array_push( $t_where_clauses, "($t_bug_table.date_submitted BETWEEN ".db_prepare_date($t_start_string)." AND ".db_prepare_date($t_end_string)." )" );

With all change, date filter can work with oracle