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(dot)klaver(at)gmail(dot)com