Re: optimize/cleanup SQL

On Fri, 29 May 2009 08:13:32 -0500 (CDT)
Brandon Metcalf <brandon@geronimoalloys.com> wrote:

> For some reason this doesn't give me satisfaction that it's written
> optimally, but I haven't found another way.
>
>   SELECT round(CAST ((EXTRACT(EPOCH FROM clockout)
>               -EXTRACT(EPOCH FROM clockin))/3600 AS NUMERIC),2) AS
> hours FROM timeclock;

satisfying?

template1=# select extract(days from ('2009-01-01'::timestamp -
'2008-01-01'::timestamp))+5::int;

?column?
----------
      371
(1 row)


--
Ivan Sergio Borgonovo
http://www.webthatworks.it