Home > mailing lists

How to return an Int4 when subtracting dates/timestamps - Mailing list pgsql-general

From	Andre Lopes
Subject	How to return an Int4 when subtracting dates/timestamps
Date	May 18, 2010 22:14:20
Msg-id	AANLkTim-16OtOF0ymbY6iWd9cgYKGXRQTnjz_Qcjky2F@mail.gmail.com Whole thread Raw
List	pgsql-general

Tree view

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,

pgsql-general by date:

From: Hernan Danielan
Date: 18 May 2010, 19:19:00
Subject: Connection lost

From: Tim Landscheidt
Date: 18 May 2010, 23:23:16
Subject: Re: How to return an Int4 when subtracting dates/timestamps

How to return an Int4 when subtracting dates/timestamps - Mailing list pgsql-general

Previous

Next