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