Re: 'NOW' in UTC with no timezone - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: 'NOW' in UTC with no timezone
Date
Msg-id 20041012144351.K568@hermes.hilbert.loc
Whole thread Raw
In response to Re: 'NOW' in UTC with no timezone  (Greg Stark <gsstark@mit.edu>)
Responses Re: 'NOW' in UTC with no timezone  (Michael Glaesemann <grzm@myrealbox.com>)
List 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

pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: update query confusion
Next
From: Michael Glaesemann
Date:
Subject: Re: 'NOW' in UTC with no timezone