day interval

From: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Cc: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Subject: day interval
Date: 2019-10-12 15:21:26
Message-ID: a95dd36dcc5d4e7380550a727716cfe0@phx-exmbprd-01.adprod.bmc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

A question on day interval

select date('20191001') - date('20190923');

Will provide sometimes '8' - an integer , but sometimes '8 day' - a string

How can I control it to return integer always?

Thanks

Danny

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Gierth 2019-10-12 15:25:38 Re: day interval
Previous Message Daniel Verite 2019-10-12 13:52:27 Re: Perl DBI converts UTF-8 again to UTF-8 before sending it to the server