time calculations

Поиск
Список
Период
Сортировка
Искать

time calculations

От:
Oliver Vecernik <vecernik@aon.at>
Дата:
Hi,

I've got a table with two columns: one for distance in km (float4) and
one for the time (interval). I'd like to calculate the speed.

My problem is how to convert the intervals to decimal hours to be able
to a simple:

SELECT *, distance/time as speed from table;

Any clues? Are there any docs (maybe I have overseen something)?

Regards,
Oliver

Re: time calculations

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Oliver Vecernik  writes:
> My problem is how to convert the intervals to decimal hours

See date_part('epoch', interval_value)

			regards, tom lane
FAQ