Postgres Pro
Downloads
Home   >   mailing lists

day interval - Mailing list pgsql-general

From Abraham, Danny
Subject day interval
Date
Msg-id a95dd36dcc5d4e7380550a727716cfe0@phx-exmbprd-01.adprod.bmc.com
Whole thread Raw
Responses Re: day interval
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: Perl DBI converts UTF-8 again to UTF-8 before sending it to the server
Next
From: Andrew Gierth
Date:
Subject: Re: day interval