Re: age() vs. timestamp substraction

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: age() vs. timestamp substraction
Дата
Msg-id 29752.1160073444@sss.pgh.pa.us
обсуждение исходный текст
Ответ на age() vs. timestamp substraction  (Martin Marques <martin@bugs.unl.edu.ar>)
Ответы Re: age() vs. timestamp substraction  (Martin Marques <martin@bugs.unl.edu.ar>)
Re: age() vs. timestamp substraction  (Jean-Paul Argudo <jean-paul@argudo.org>)
Список pgsql-sql
Martin Marques <martin@bugs.unl.edu.ar> writes:
> I just found this problem with the age() function, which AFAIK should
> give the same resulte as a subtraction of the argument from now(),

Where did you get that idea?  age's reference point is current_date (ie,
midnight) not now().  There are also some differences in the calculation
compared to a plain timestamp subtraction.
        regards, tom lane


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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: Assigning a timestamp without timezone to a timestamp
Следующее
От: Martin Marques
Дата:
Сообщение: Re: age() vs. timestamp substraction