Re: [GENERAL] day_trunc and day duration in a remote time zone

2013-10-17 Thread Adrian Klaver
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 curre

[GENERAL] day_trunc and day duration in a remote time zone

2013-10-17 Thread Marc Mamin
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. the queries below works as expected, but I would appreciate a simpler solution ... example: ( http://localtimes.info/Europe/Cyprus/Nicosia/ ) select (