| Lists: | pgsql-general |
|---|
| From: | Andre Lopes <lopes80andre(at)gmail(dot)com> |
|---|---|
| To: | postgresql Forums <pgsql-general(at)postgresql(dot)org> |
| Subject: | How to return an Int4 when subtracting dates/timestamps |
| Date: | 2010-05-18 22:14:04 |
| Message-ID: | AANLkTim-16OtOF0ymbY6iWd9cgYKGXRQTnjz_Qcjky2F@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Hi,
I need to return an Int4 when I do this king of select
[code]
select CURRENT_DATE - '2009-12-31' from tbl_sometable
[/code]
This select returns an Interval. How can I return an Integer? Like '138'
Sorry my bad english.
Best Regards,
| From: | Tim Landscheidt <tim(at)tim-landscheidt(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to return an Int4 when subtracting dates/timestamps |
| Date: | 2010-05-18 23:22:49 |
| Message-ID: | m3y6fglrqu.fsf@passepartout.tim-landscheidt.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Andre Lopes <lopes80andre(at)gmail(dot)com> wrote:
> I need to return an Int4 when I do this king of select
> [code]
> select CURRENT_DATE - '2009-12-31' from tbl_sometable
> [/code]
> This select returns an Interval. How can I return an Integer? Like '138'
That expression returning an interval would be contradictory
to the documentation and a simple test:
| tim=# SELECT CURRENT_DATE - '2009-12-31';
| ?column?
| ----------
| 138
| (1 Zeile)
| tim=# SELECT CURRENT_DATE::TIMESTAMP - '2009-12-31';
| ?column?
| ----------
| 138 days
| (1 Zeile)
| tim=#
So how far away from "this kind of select" is your actual
query?
Tim