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
[email protected]
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
