ERROR: invalid input syntax for type date: ""

Question

I have the following psql query and can't understand why I get error ERROR: invalid input syntax for type date: "".

My query looks as follows:

SELECT count(*) FROM campaigns 
WHERE 
    dstart >= '2010-09-02' AND 
    dend <= '2010-09-02' AND 
    status != 'S' AND 
    status != 'C' AND 
    status != 'E' AND 
    (dsignoff <> '' AND dsignoff is not null) AND 
    (dstart <> '' AND dstart is not null) AND 
    (dend <> '' AND dend is not null) AND 
    clientid=20005294;

dstart,dend and dsignoff are all defined as date types.

Alex Reitbort · Accepted Answer · 2010-09-02 12:00:14Z

12

Since dstart,dend and dsignoff are defined as date, they can not be compared to string that represents invalid date (''). Try this:

SELECT count(*) FROM campaigns 
WHERE 
    dstart >= '2010-09-02' AND 
    dend <= '2010-09-02' AND 
    status != 'S' AND 
    status != 'C' AND 
    status != 'E' AND 
    (dsignoff is not null) AND 
    (dstart is not null) AND 
    (dend is not null) AND 
    clientid=20005294;

answered Sep 2, 2010 at 12:00

Alex Reitbort

13.7k1 gold badge44 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ERROR: invalid input syntax for type date: ""

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related