optimize/cleanup SQL

Поиск
Список
Период
Сортировка
От Brandon Metcalf
Тема optimize/cleanup SQL
Дата
Msg-id Pine.LNX.4.58L.0905290807250.17654@cedar.geronimoalloys.com
обсуждение исходный текст
Ответы Re: optimize/cleanup SQL  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Re: optimize/cleanup SQL  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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;

The clockin and clockout columns are of type timestamp.

Is there a faster way to achieve this?  If not faster, a cleaner way
that executes as fast?


--
Brandon

В списке pgsql-general по дате отправления:

Предыдущее
От: Geoffrey
Дата:
Сообщение: Re: pg_usleep() location
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: pg_usleep() location