Select from SQL tables

Question

Good morning, everyone! I’m performing the select below:

select * from orcamento 
        where 
        status_orcamento = 'A' 
        and data_conclusao_orcamento > 2021-05-31 

My question is: Information should only come above day 31/05/2021 correct?

Answer 1

No! SQL is recognizing its "2021-05-31" as a mathematical expression and not as a date. Try:

select * from orcamento 
        where 
        status_orcamento = 'A' 
        and data_conclusao_orcamento > Convert(datetime, '2021-05-31')

Or else, a way not so correct:

select * from orcamento 
        where 
        status_orcamento = 'A' 
        and data_conclusao_orcamento > '2021-05-31' ;

Tell me if it worked!