> 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?
>
Hmm. Just a guess, but could this be a time zone thing?