Compare dates in SQL statement

Question

I'm trying to use the following statement to check if the order is late, but it causes syntax error. How can I write it ?

select (enddate > targetdate ) as late from orders

SELECT enddate, targetdate FROM orders WHERE enddate > targetdate ? — Devart
– Devart, Commented Dec 24, 2015 at 11:47
What are you going to do with this flag? If it's only for display purposes, it's OK. If you want to use this flag for filtering though, it would be faster to handle late entries separately. — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Dec 24, 2015 at 11:53

Andrey Korneyev · Accepted Answer · 2015-12-24 11:50:09Z

4

It looks like you're searching something similar to case expression:

select 
    case 
        when enddate > targetdate then 1 
        else 0 
    end as late
from orders

answered Dec 24, 2015 at 11:50

Andrey Korneyev

26.9k16 gold badges73 silver badges72 bronze badges

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

Comments

Pரதீப் · Accepted Answer · 2015-12-24 11:51:30Z

1

I guess you need case

select 
    case 
        when enddate > targetdate then 'enddate  is greater' 
        else 'targetdate is greater' 
    end as late
from orders

answered Dec 24, 2015 at 11:51

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges