On 10/17/2013 08:47 AM, Marc Mamin wrote:
Hello,
I want to retrieve the day start and duration of an epoch within a
given time zone
and return the day start as epoch.
Not quite sure what you are looking for, but something like:
hplc=> select current_date::timestamp, extract(epoch from
current_date::timestamp);
timestamp | date_part
---------------------+------------
2013-10-17 00:00:00 | 1381968000
regards,
Marc Mamin
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
