Reputation: 1621

Compare dates in SQL statement

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

Upvotes: 0

Answers (2)

Reputation: 93704

I guess you need case

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

Upvotes: 1

Reputation: 26856

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

Upvotes: 4