epoch from date field - Mailing list pgsql-general

From Laurette Cisneros
Subject epoch from date field
Date
Msg-id Pine.LNX.4.44.0207031152390.25257-100000@visor.corp.nextbus.com
Whole thread Raw
Responses Re: epoch from date field  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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




pgsql-general by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: Comparing PostgreSQL and Oracle stability
Next
From: "Booth, Robert"
Date:
Subject: Query Analyzing