function to find difference between in days between two dates

Поиск
Список
Период
Сортировка
От Ashish Karalkar
Тема function to find difference between in days between two dates
Дата
Msg-id 006101c7ae4c$ed7edbd0$170211ac@LIONKING.COM
обсуждение исходный текст
Ответы Re: [SQL] function to find difference between in days between two dates  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Список pgsql-general
Дерево обсуждения
Hello all,
 
Is there any function to find  differences in days between two dates?
 
 
I am using
 
select abs(current_date - '2007-06-15')
 
to get the desired result.
but I think there must be a function and I am missing it,
if so, can anybody please point me to that.
 
 
Thanks in advance
 
With regards
Ashish Karalkar
 
 
 

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

Предыдущее
От: "Robin Ericsson"
Дата:
Сообщение: Re: changing the /tmp/ lock file?
Следующее
От: "Pavel Stehule"
Дата:
Сообщение: Re: [SQL] function to find difference between in days between two dates