Date is incompatible with Oracle Driver

It has not been tested at all with Oracle. Someone who knows Oracle would have to provide a patch to make the necessary changes to date_api_sql.inc in the Date API module, following the same pattern that was used for other database engines.

tested on ORACLE and still does not work, it is still something changed?

Yo tengo el mismo problema, no hay solución aún?

I have the same problem, no solution yet?

The README.txt file says "The SQL functions are found in date_api_sql.inc, which is not included by default. Include that file if you want to use these functions:" but I have no idea where to include it to. So if I attempt at getting this to work where do I include the file? Is it just this file we need to edit to get it to work with Oracle?

What is the resolution to this issue? We encountered the same problem.

I saw date_api_sql.inc and it was included at date.module.

Does anyone knows the solution?

got the answer for oracle...

use the drupal admin... manage field and change the field type of the date into unix_timestamp or ISO

thant's it!.. hope it will help

got the answer for oracle...

use the drupal admin... manage field and change the field type of the date into unix_timestamp or ISO

that's it!.. hope it will help

Contextual filters with date are not supported. The date_api_sql.inc file states a todo feature for oracle support, together with a coworker, we created the patch in attachment with the required date/ time cases for oracle db_type.
Development setup is

• Drupal 7.27
• database type > oracle 11g
• date 7.x-2.7
• PHP 5.4.4

Requesting review on this patch to be included in future releases of the date module, thanks.

I have skiped a step (switch to my local branch) when creating the patch, I'm going trough the patch to resubmit.

Resubmit patch for retest

@ricardojmartins

I had a client on Oracle 11g last year and also had to write custom code to support the Date module. Our solutions are very similar! :-) I cannot test it (nor yours) anymore as the project finally migrated to MySQL, but maybe that bit of code could help out. Take what you want from it!

Bot

Hi i want to declare this affect the user registration process if exists a custom date field using the format "date" it can be fixed setting the format to "date unix".

The error on registration process is:

DatabaseTransactionNoActiveException: in DatabaseConnection->rollback() (line 1038 of /var/www/html/includes/database/database.inc).

I trace the error to the function user_save when call field_attach_insert.