Re: 'NOW' in UTC with no timezone

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: 'NOW' in UTC with no timezone
Date: 2004-10-12 12:43:51
Message-ID: 20041012144351.K568@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > > I'm trying to determine the best way of saying 'The current time in UTC
> > > with no time zone information'.
> >
> > Isn't that a contradiction in terms?
>
> Not if you're used to the Unix concept of storing "seconds since the epoch".
> In that model the quantity you're storing is entirely time zone agnostic.
But then one is storing an interval, not a point in time.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Boes 2004-10-12 12:50:48 Rule uses wrong value
Previous Message Sim Zacks 2004-10-12 12:43:18 update query confusion