Re: [GENERAL] Extracting time from timestamp - Mailing list pgsql-hackers

> phd=# select time(abstime(timestamp 'now')) from bookings;
> ERROR:  parser: parse error at or near "abstime" at character 13
> phd=# select time(timestamp 'now') from bookings;
> ERROR:  parser: parse error at or near "timestamp" at character 13
> phd=# select version();
>                                version

Try:

select "time"(abstime(timestamp 'now')) from bookings;
select "time"(timestamp 'now') from bookings;

Chris