[Rails] Date formats

[Rails] Date formats

	Scott Ribe
	Oct 25, 2011 at 6:01 pm

On Oct 25, 2011, at 11:50 AM, Tom Allison wrote:

timestamp with time zone

Which means that it is offset by postgres to/from the time zone of the client making the query, your rails app in this case. Timestamp without time zone makes no adjustments, just storing/retrieving it as supplied.

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice

--
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-talk@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

Search Discussions

Discussion Posts

Tom Allison: OK, so the default time saved is UTF-8. Which means that storing it a what appears to be now+4 hours is correct. I think my question falls into a postgresql question. When I query these fields it appears as the time (16:00 instead of 12:00) is identified as "timestamp with time zone" -- unexpected. I don't think I quite understand what it is I am looking at... -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send

Follow ups

Related Discussions

Discussion Navigation

view	thread \| post
posts	‹ prev \| 4 of 7 \| next ›

Discussion Overview

group	rubyonrails-talk @
categories	rubyonrails
posted	Oct 25, '11 at 4:53p
active	Oct 28, '11 at 11:34p
posts	7
users	5
website	rubyonrails.org
irc	#RubyOnRails

font	variable	Hotkey: f
user style	avatars	Hotkey: a

[Rails] Date formats

Search Discussions

Discussion Posts

Related Discussions

5 users in discussion