Home > mailing lists

function to find difference between in days between two dates - Mailing list pgsql-general

From	Ashish Karalkar
Subject	function to find difference between in days between two dates
Date	June 14, 2007 06:31:03
Msg-id	006101c7ae4c$ed7edbd0$170211ac@LIONKING.COM Whole thread Raw
Responses	Re: [SQL] function to find difference between in days between two dates ("Pavel Stehule" <pavel.stehule@gmail.com>)
List	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

From: "Robin Ericsson"
Date: 14 June 2007, 06:24:24
Subject: Re: changing the /tmp/ lock file?

From: "Pavel Stehule"
Date: 14 June 2007, 07:00:34
Subject: Re: [SQL] function to find difference between in days between two dates