Ah.. my definition of MDT was flawed; thanks for the help!<br /><br /> Alvaro Herrera wrote: <blockquote
cite="mid:20080822011725.GX4169@alvh.no-ip.org"type="cite"><pre wrap="">Tom Lane wrote: </pre><blockquote
type="cite"><prewrap="">Dave Witt <a class="moz-txt-link-rfc2396E"
href="mailto:dwitt@movenetworks.com"><dwitt@movenetworks.com></a>writes: </pre><blockquote type="cite"><pre
wrap="">Thesetwo queries produce different output, using version 8.3.3:
SELECT '2008-01-01 00:00:00+00'::timestamptz AT TIME ZONE 'MDT';
SELECT '2008-01-01 00:00:00+00'::timestamptz AT TIME ZONE 'America/Boise'; </pre></blockquote><pre wrap="">Why are
yousurprised? Boise would've been on MST not MDT on that date. </pre></blockquote><pre wrap="">
i.e. try using MST7MDT instead, which behaves more sanely.
--
Alvaro Herrera <a class="moz-txt-link-freetext"
href="http://www.CommandPrompt.com/">http://www.CommandPrompt.com/</a>
The PostgreSQL Company - Command Prompt, Inc. </pre></blockquote><br />