Re: epoch from date field - Mailing list pgsql-general

From Lee Harr
Subject Re: epoch from date field
Date
Msg-id ag0e6v$jam$1@news.hub.org
Whole thread Raw
In response to epoch from date field  (Laurette Cisneros <laurette@nextbus.com>)
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?
>

Hmm. Just a guess, but could this be a time zone thing?









pgsql-general by date:

Previous
From: Hiroki Takada
Date:
Subject: Re: permissions in PgSQL 7.2.1
Next
From: Justin Clift
Date:
Subject: Libre Software Meeting - Université Bordeaux I, France