Hrm, yet Bruce mentions it in one of his documents.
http://momjian.us/main/writings/pgsql/data_processing.pdf
It may be undocumented, but it get a lot of hits on google :)
why google? look to pgsql/src/backend/utils/adt/date.c :-)
Regards
Pavel Stehule
---(end of br
2007/6/14, Martijn van Oosterhout <[EMAIL PROTECTED]>:
On Thu, Jun 14, 2007 at 09:00:12AM +0200, Pavel Stehule wrote:
> Hello
>
> PostgreSQL hasn't any official function for it. If you need it, you
> can write own function
Not true. Anything that is done by an operator as actually done by a
func
2007/6/14, A. Kretschmer <[EMAIL PROTECTED]>:
am Thu, dem 14.06.2007, um 11:56:15 +0530 mailte Ashish Karalkar folgendes:
> Hello all,
>
> Is there any function to find differences in days between two dates?
Yes, age().
there is difference
date - date --> integer
age(date::timestamp, date
am Thu, dem 14.06.2007, um 11:56:15 +0530 mailte Ashish Karalkar folgendes:
> Hello all,
>
> Is there any function to find differences in days between two dates?
Yes, age().
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FF
Hello
PostgreSQL hasn't any official function for it. If you need it, you
can write own function
CREATE FUNCTION date_diff(date, date) returns integer as $$
select $1-$2; $$ language sql;
Regards
Pavel Stehule
2007/6/14, Ashish Karalkar <[EMAIL PROTECTED]>:
Hello all,
Is there any function
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 regar
