Oracle adapter: datetime_select problem

rubyonrails-core
1

I'm having a problem using the datetime_select helper for data held in an Oracle (10g) database.

The data is stored in Oracle as DATE and the helper works fine if there is a non-zero time component of the date. Unfortunately if there isn't a time component (ie. the time value is midnight - 00:00:00) then it breaks with the following error message: -

NoMethodError in Weeks#edit ... private method `min' called for #<Date: 4908799/2,0,2299161>

From what I can gather it looks like the code is seeing the zero time value and therefore casting the data into a DATE type rather than a DATETIME.

Any assistance would be appreciated.

John

2

I'm having a problem using the datetime_select helper for data held in an Oracle (10g) database.

The data is stored in Oracle as DATE and the helper works fine if there is a non-zero time component of the date. Unfortunately if there isn't a time component (ie. the time value is midnight - 00:00:00) then it breaks with the following error message: -

NoMethodError in Weeks#edit ... private method `min' called for #<Date: 4908799/2,0,2299161>

From what I can gather it looks like the code is seeing the zero time value and therefore casting the data into a DATE type rather than a DATETIME.

Any assistance would be appreciated.

The oracle adapter is maintained by Michael Schoen, so he's probably the best person to ask about why it's doing that. It would appear to be deliberate though.