On Feb 28, 2011, at 8:06 AM, Rob Richardson wrote:
> But if PostgreSQL doesn’t store time zones internally, then that difference is going to be 24 hours, which doesn’t
helpme.
No, postgres stores timestamptz as UTC, so that calculation will work exactly like you want.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice