epoch from date field

From: Laurette Cisneros <laurette(at)nextbus(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: epoch from date field
Date: 2002-07-03 18:53:41
Message-ID: Pine.LNX.4.44.0207031152390.25257-100000@visor.corp.nextbus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


When extracting the epoch from a date:

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?

Thanks,

--
Laurett Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
"Intelligence complicates. Wisdom simplifies."
-- Mason Cooley

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Manfred Koizar 2002-07-03 19:09:24 Re: One source of constant annoyance identified
Previous Message Nick Fankhauser 2002-07-03 18:30:24 Re: Comparing PostgreSQL and Oracle stability