On Wed, Jan 25, 2012 at 07:44:14AM -0800, Adrian Klaver wrote: > > I thought that this is what I will achieve with extract(epoch from now() > > at time zone 'UTC') but clearly it doesn't work. > > So what options do I have? > > Isn't extract(epoch from now()) getting what you want? you can't make index on it. Best regards, depesz -- The best thing about modern society is how easy it is to avoid contact with it. http://depesz.com/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general