SET TIMEZONE doesn't affect to SELECT statement

From: POST <post(at)centrum(dot)sk>
To: pgsql-general(at)postgresql(dot)org
Subject: SET TIMEZONE doesn't affect to SELECT statement
Date: 2009-06-18 16:02:06
Message-ID: 1598771712.20090618180206@centrum.sk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><title>SET TIMEZONE doesn't affect to SELECT statement</title>
<META http-equiv=Content-Type content="text/html; charset=windows-1250">
<meta http-equiv="Content-Style-Type" content="text/css">
<style type="text/css"><!--
body {
margin: 5px 5px 5px 5px;
background-color: #ffffff;
}
/* ========== Text Styles ========== */
hr { color: #000000}
span.rvts1 /* Heading */
{
font-size: 10pt;
font-family: 'Arial';
font-weight: bold;
color: #0000ff;
}
span.rvts2 /* Subheading */
{
font-size: 10pt;
font-family: 'Arial';
font-weight: bold;
color: #000080;
}
span.rvts3 /* Keywords */
{
font-size: 10pt;
font-family: 'Arial';
font-style: italic;
color: #800000;
}
a.rvts4, span.rvts4 /* Jump 1 */
{
font-size: 10pt;
font-family: 'Arial';
color: #008000;
text-decoration: underline;
}
a.rvts5, span.rvts5 /* Jump 2 */
{
font-size: 10pt;
font-family: 'Arial';
color: #008000;
text-decoration: underline;
}
span.rvts6
{
font-size: 8pt;
font-family: 'arial';
font-style: italic;
color: #c0c0c0;
}
a.rvts7, span.rvts7
{
font-size: 8pt;
font-family: 'arial';
color: #0000ff;
text-decoration: underline;
}
/* ========== Para Styles ========== */
p,ul,ol /* Paragraph Style */
{
text-align: left;
text-indent: 0px;
padding: 0px 0px 0px 0px;
margin: 0px 0px 0px 0px;
}
.rvps1 /* Centered */
{
text-align: center;
}
--></style>
</head>
<body>

<p>Hello; by tutorial I have tried the example:</p>
<p><br></p>
<p>set timezone to 'Europe/London';</p>
<p>select '2008-01-01 12:00:00 GMT+2'::timestamptz;</p>
<p><br></p>
<p>Result: 2008-01-01 15:00:00</p>
<p><br></p>
<p><br></p>
<p>set timezone to 'Europe/Moscow';</p>
<p>select '2008-01-01 12:00:00 GMT+2'::timestamptz;</p>
<p><br></p>
<p>Result: 2008-01-01 15:00:00</p>
<p><br></p>
<p><br></p>
<p>Why is the result identical ? Is something wrong ?</p>
<p><br></p>
<p>Thanks for suggestion.</p>

</body></html>

Attachment Content-Type Size
unknown_filename text/html 1.9 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Christensen 2009-06-18 17:20:49 Re: SET TIMEZONE doesn't affect to SELECT statement
Previous Message Lennin Caro 2009-06-18 15:23:05 Re: connecting to a remote pq always require a password