Re: How to compare dates from two tables with blanks values

From: "Arnaud L(dot)" <arnaud(dot)listes(at)codata(dot)eu>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to compare dates from two tables with blanks values
Date: 2018-12-19 10:57:38
Message-ID: 90466dc3-66f2-7db4-b716-6a5d344a1b49@codata.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le 19/12/2018 à 11:41, Mike Martin a écrit :
> cast(nullif(d.joineddate,NULL) as timestamp) != cast(nullif(s.joineddate,'') as timestamp)
Try with
d.joineddate IS DISTINCT FROM s.joineddate

https://www.postgresql.org/docs/current/functions-comparison.html

Cheers
--
Arnaud

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Михаил Яремчук 2018-12-19 11:15:09 Error on insert xml
Previous Message Mike Martin 2018-12-19 10:41:19 How to compare dates from two tables with blanks values