[Rails] Re: created_at, updated_at and MSSQL

2010-12-14 Thread pepe
> Use created_at.localtime.strftime( ) Couldn't have been any easier. Thanks Colin. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-t...@googlegroups.com. To unsubscribe from this gro

Re: [Rails] Re: created_at, updated_at and MSSQL

2010-12-14 Thread Colin Law
On 14 December 2010 13:46, pepe wrote: > >> So there is never any ambiguity about timestamps in the database.  For >> example, suppose you move to a server in another timezone, it can get >> very messy if you have timestamps in EST or whatever happens to be >> your local timezone today.  By keepin

[Rails] Re: created_at, updated_at and MSSQL

2010-12-14 Thread pepe
> So there is never any ambiguity about timestamps in the database.  For > example, suppose you move to a server in another timezone, it can get > very messy if you have timestamps in EST or whatever happens to be > your local timezone today.  By keeping all timestamps in the db in UTC > you will

Re: [Rails] Re: created_at, updated_at and MSSQL

2010-12-14 Thread Colin Law
On 14 December 2010 01:26, pepe wrote: >> The value in the db should be UTC, so may be correct, dependent on >> where you are. > > Thanks Colin, > > I am in the US, EST. UTC is 5 hours ahead of me (rake time:zones:all). > For a multiple time zone application I understand that having UTC > would be

[Rails] Re: created_at, updated_at and MSSQL

2010-12-13 Thread pepe
> The value in the db should be UTC, so may be correct, dependent on > where you are. Thanks Colin, I am in the US, EST. UTC is 5 hours ahead of me (rake time:zones:all). For a multiple time zone application I understand that having UTC would be "the" option. Is there a reason I am not aware of w

[Rails] Re: created_at, updated_at and MSSQL

2010-12-13 Thread pepe
Thanks, the time_zone value in environment.rb is the reason this is happening. On Dec 13, 5:05 pm, Anton Anykeyev wrote: > check timezone settings in your environment configs > > -- > Posted viahttp://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Gro

[Rails] Re: created_at, updated_at and MSSQL

2010-12-13 Thread Anton Anykeyev
check timezone settings in your environment configs -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-t...@googlegroups.com. To unsubscribe from th