On Mon, Apr 25, 2005 at 11:36:23AM -0400, Tom Lane wrote:
> > ---+---
> > 2005-04-24 22:25:51.669218+00 | 2005-04-24 23:25:51.669218+01
>
> It was not really possible in 7.1 either (nor any previous version).
> The secret to the above is th
Michael Fuhr <[EMAIL PROTECTED]> writes:
> The problem I was discussing involves getting *different* time zone
> specifictions in the output. That is, something like this (which
> apparently is possible in 7.1.3 but not in later versions):
>f | timezone
> > > select f, f::timestamp at time zone 'MEZ' from test;
> > > f | timezone
> > > ---+
> > >2005-04-24 22:25:51.669218+00 | 2005-04-24 23:25:51.669218
> > > (1 row)
> >
> > Huh ? Th
On Mon, Apr 25, 2005 at 08:28:47AM +0200, Karsten Hilbert wrote:
> > > gnumed=> create teable test (f timestamp with time zone);
> > > CREATE
> >
> > Does that really work in 7.1.3? Trying to create a "teable" fails
>
> This results from "script" logging backspaces into the log
> file instead of
On Mon, Apr 25, 2005 at 03:05:12AM -0400, Tom Lane wrote:
> > The fact that different versions of PostgreSQL get it right or
> > wrong in a variety of ways indicates that the logic may need
> > to be fixed but does show that in principle it is quite
> > possible.
>
> 7.1's version of AT TIME ZONE
Karsten Hilbert <[EMAIL PROTECTED]> writes:
> The fact that different versions of PostgreSQL get it right or
> wrong in a variety of ways indicates that the logic may need
> to be fixed but does show that in principle it is quite
> possible.
7.1's version of AT TIME ZONE was so badly broken that i
On Sun, Apr 24, 2005 at 04:34:31PM -0600, Michael Fuhr wrote:
> > gnumed=> select version();
> > version
> > ---
> > PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.95.3
>
On Sun, Apr 24, 2005 at 07:09:44PM +0200, Karsten Hilbert wrote:
> Isn't the following what you want?
...
> gnumed=> select version();
> version
> ---
> PostgreSQL 7.1.3 on i686-pc-l
On Sun, Apr 24, 2005 at 10:49:13AM -0600, Michael Fuhr wrote:
> > > As far as I know, it's not possible to get output like the following
> > > from the same query if the data type is timestamp with time zone:
> > >
> > > 2005-04-21 15:00:00-07
> > > 2005-04-21 22:00:00+00
> >
> > Doesn't "at tim
On Sun, Apr 24, 2005 at 05:21:41PM +0200, Karsten Hilbert wrote:
> >
> > As far as I know, it's not possible to get output like the following
> > from the same query if the data type is timestamp with time zone:
> >
> > 2005-04-21 15:00:00-07
> > 2005-04-21 22:00:00+00
>
> Doesn't "at time zone"
> As far as I know, it's not possible to get output like the following
> from the same query if the data type is timestamp with time zone:
>
> 2005-04-21 15:00:00-07
> 2005-04-21 22:00:00+00
Doesn't "at time zone" do what you need ?
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A29
On Thu, Apr 21, 2005 at 05:56:41PM -0700, Steve - DND wrote:
>
> Okay, I understand what you're saying now, but then is a time without a
> timezone implicitly assumed to be UTC? Is there a way to explicitly make the
> timezone on the stamp be UTC, if the prior is not the case?
See "Date/Time Type
>
> Again looking at the documentation, we see that "timestamp with
> time zone AT TIME ZONE zone" means "Convert UTC to local time in
> given time zone" and has a return type of "timestamp without time
> zone". So if we run the above command without the final cast
> around 16:25 PDT / 23:25 UTC,
On Thu, Apr 21, 2005 at 04:11:57PM -0700, Steve - DND wrote:
> >
> > Perhaps this is what you want:
> >
> > SELECT timezone('UTC', timeofday()::timestamptz);
>
> That did it. Strangely, I thought I had tried that already, but I must not
> have. My next question would be if I did:
>
> SELE
>
> Perhaps this is what you want:
>
> SELECT timezone('UTC', timeofday()::timestamptz);
That did it. Strangely, I thought I had tried that already, but I must not
have. My next question would be if I did:
SELECT timezone('UTC', timeofday()::timestamptz):timestamptz;
Why do I get the t
On Thu, Apr 21, 2005 at 01:35:16PM -0700, Steve - DND wrote:
> These attempts were run at 4/21/2005 13:15:00 -07.
> UTC: 4/21/2005 20:15:00
>
> SELECT timeofday()::timestamp
> 04/21/2005 13:15:00
>
> SELECT timezone('UTC', now())
> 04/21/2005 20:15:00 PM
>
> SELECT timezone('UTC', timeofday()::t
These attempts were run at 4/21/2005 13:15:00 -07.
UTC: 4/21/2005 20:15:00
SELECT timeofday()::timestamp
04/21/2005 13:15:00
SELECT timezone('UTC', now())
04/21/2005 20:15:00 PM
SELECT timezone('UTC', timeofday()::timestamp)::timestamp without time zone
04/21/2005 06:15:00 <- What the heck is th
17 matches
Mail list logo