Determining period between 2 dates
| От | Thom Brown |
|---|---|
| Тема | Determining period between 2 dates |
| Дата | |
| Msg-id | AANLkTimHgQfzZPYY2Wq66VaOLxp=G5Cit4_uKgQBigiA@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Determining period between 2 dates
|
| Список | pgsql-hackers |
Hi all, I'm wondering what people think of introducing some kind of function to extract the number of units between 2 dates? At the moment there's no way to do this. Take the following example: Event 1 is '1985-10-26 01:22:00' Event 2 is now. How many minutes between these 2 events? What I don't want is how many years, months, days and hours there are between them. This could potentially involve implementing age(timestamp, timestamp, interval), like: postgres=# SELECT age(current_date, '1985-10-26 01:22:00'::timestamp, '1 second') as age_in_seconds;age_in_seconds ---------------- 798733367 (1 row) Is this easily done? Thanks -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935
В списке pgsql-hackers по дате отправления: