Postgres Pro
Downloads
Home   >   mailing lists

Re: How to compare dates from two tables with blanks values - Mailing list pgsql-general

From Arnaud L.
Subject Re: How to compare dates from two tables with blanks values
Date
Msg-id 90466dc3-66f2-7db4-b716-6a5d344a1b49@codata.eu
Whole thread Raw
In response to How to compare dates from two tables with blanks values  (Mike Martin <redtux1@gmail.com>)
Responses Re: How to compare dates from two tables with blanks values  (Mike Martin <redtux1@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Mike Martin
Date:
Subject: How to compare dates from two tables with blanks values
Next
From: Ron
Date:
Subject: Re: Format an Update with calculation