Re: Dates

From: Andrew Rawnsley <ronz(at)ravensfield(dot)com>
To: MaRCeLO PeReiRA <gandalf_mp(at)yahoo(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dates
Date: 2004-02-16 19:53:13
Message-ID: C12259DB-60B9-11D8-BD8B-000393A47FCC@ravensfield.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Subtracting two dates/timestamps will return an interval. So

select now()::date - '2004-01-13'::date

returns 34.

Is this what you need?

On Feb 16, 2004, at 2:01 PM, MaRCeLO PeReiRA wrote:

> Hi Guys,
>
> I am in troubles with some dates.
>
>
> "I need to know the difference, in days, between two
> dates."
>
> Well, if the difference is less than a month, so I
> could use:
>
> SELECT date_part('day', age(now(), mydate));
>
> But, when it is bigger than a month, the select above
> return a wrong information to me:
>
> For instance:
>
> intranet=# select age('30/01/2004', '01/03/2004');
> age
> -----------------------
> @ 1 mon 2 days 1 hour
>
> So, if I use date_part(), it would return "2 days",
> not "31 days", that is what I was waiting for.
>
> How can I get the difference, in days, between two
> dates???
>
> Thanks in advance and
> Best Regards,
>
>
>
> ______________________________________________________________________
>
> Yahoo! Mail - O melhor e-mail do Brasil! Abra sua conta agora:
> http://br.yahoo.com/info/mail.html
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
--------------------

Andrew Rawnsley
President
The Ravensfield Digital Resource Group, Ltd.
(740) 587-0114
www.ravensfield.com

In response to

  • Dates at 2004-02-16 19:01:58 from MaRCeLO PeReiRA

Responses

  • Re: Dates at 2004-02-16 20:05:52 from MaRCeLO PeReiRA

Browse pgsql-general by date

  From Date Subject
Next Message MaRCeLO PeReiRA 2004-02-16 20:05:52 Re: Dates
Previous Message Stephan Szabo 2004-02-16 19:52:17 Re: Dates