Oracle Date + RoR

rubyonrails-talk
1

Hi Experts,

I've a model called Product where i've column called created_at, updated_at

where i've made a query based on Oracle date format

like

date_of_created = '23-SEP-07' @product = Product.find(:all, :conditions => ["created_at=?", date_of_created])

but in view its empty.

AND EXPERTS I'VE DATA WITH 24-SEP-07 FOR MORE THAN 10 RECORDS, AND I'VE MINOR DOUBT BASED ON STRUCTURE OF A TABLE I MEANT THE TYPE OF CREATED_AT COLUMN, LIKE WHEN I DO MIGRATE I MADE CREATED_AT as datetime, but oracle supports date type, is there any difference?

regards,

Bala

2

Yes, the oracle date column doesn’t contain time. Im not to sure about this but try adding .to_time to your date_of_created

@product = Product.find(:all, :conditions => [“created_at=?”, date_of_created.to_time])

3

Thanks Paul, it works well.

but anyway is it good solution if i use created_at type as varchar to query?

or it'll be a probs?

4

I would definitely keep it datetime. Read up about oracle date column. There are some funnies involved. I have never used oracle so not clued up.

The issue here I believe is that the created_at field is datetime which contains date elements and time elements. the "23-Sept-07’ string doesn’t compare well. When you call .to_time in converts that string into a datetime object. This can then be nicely compared with the datetime field. I would rather change the way I do the query by always passing a datetime than change the database and work with strings.

regards ivor