# PostgreSQL 8.3 not storing 'Date' field type with Rails 3.0

**URL:** <https://www.ruby-forum.com/t/postgresql-8-3-not-storing-date-field-type-with-rails-3-0/194798>\
**Category:** Rails\
**Created:** [September 10, 2010, 9:08pm UTC](https://www.ruby-forum.com/t/postgresql-8-3-not-storing-date-field-type-with-rails-3-0/194798 "2010-09-10T21:08:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jmaenpaa](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/9de053/32.png) [@jmaenpaa](https://www.ruby-forum.com/u/jmaenpaa)\
**Post date:** [September 10, 2010, 9:08pm UTC](https://www.ruby-forum.com/t/postgresql-8-3-not-storing-date-field-type-with-rails-3-0/194798/1 "2010-09-10T21:08:43Z")

</div>

Hi there,

I’ve searched far and wide for an answer to this. I am using Rails 3.0.0  
with Postgresql8.3 and ActiveRecord. Almost everything works fine - I  
have the normal timestamps, which store correctly, and a field called  
‘time’ which is of the type ‘time’ and this works too.

However, I also have a ‘date’ field, of type ‘date’, which never stores  
any data. The data is being posted correctly through the form, but it  
never ends up in PostgreSQL, and no error messages to help.

Can anyone think of what might be going on? I’m at my wits end.

Thanks,

John

---

<div class="post-metadata">

**Author:** ![jmaenpaa](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/9de053/32.png) [@jmaenpaa](https://www.ruby-forum.com/u/jmaenpaa)\
**Post date:** [September 11, 2010, 9:36am UTC](https://www.ruby-forum.com/t/postgresql-8-3-not-storing-date-field-type-with-rails-3-0/194798/2 "2010-09-11T09:36:09Z")

</div>

attr\_accessible does not include the column maybe ?  
Could you post the code how you fill the column in the model via irb,  
the results of that and sql statement that gests executed ?

Robert Pankowecki
