Actually, we use tzset() to set the timezone. We're not operating in GMT
at all, but it returns GMT.
This, however does work returning the epoch for the current timezone:
select extract(epoch from map_date::timestamp);
So, for some reason extract won't convert a date to timestamp when it's
passed in?
Thanks for the help,
L.
On Thu, 4 Jul 2002, Tom Lane wrote:
> Laurette Cisneros <laurette@nextbus.com> writes:
> > select extract(epoch from date(map_date)) from datemaps;
> > For a date: 2002-07-04
> > it returns 1025740800
> > which apparently translates to today (7/3) at 5pm. Is this right?
> > Shouldn't it return the epoch for midnight on 7/4?
>
> You're in GMT-7 to judge by your Date: header. That *is* midnight,
> GMT.
>
> regards, tom lane
>
--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
"Intelligence complicates. Wisdom simplifies."
-- Mason Cooley
