Postgres Timestamp Fields Displayed with Time format

rubyonrails-talk
1

I have Time fields in my PostgreSQL tables, which I force to display as time only with this entry in config/locales/en.yml:

  time:     formats:       default: "%H:%M:%S"

Problem is, that format is now applied to Timestamp fields, including the default created_at and updated_at fields.

Why is it applying the Time (time only) format to a Timestamp (date + time) field, and how do I rectify this problem?

Thanks for any help or ideas.

2

Timestamp fields are stored in TimeWithZone objects, so are of type Time and your defaults will apply. You could use strftime to format those for which the default is not appropriate, or don't bother with changing the default, just use strftime always.

Colin