select current_time,extract(second from current_time);
It gives me the results as,
,for the projection list as specified in the SELECT statement.
But when I ammend it as,
select extract(second from current_time + 10);
then it gives me error. Why is that ? I believe ideally it should give me 10 seconds added to the seconds extracted from current time. i.e. if the seconds extracted from current_time is 40 then it should give me 50 and if the seconds extracted from current_time is 55 then it should give me 5 (as current_time uses clock intelligence).