Null vaules when using where clause on datetime column in AZURE SYNAPSE

Copper Contributor

Hello 
Is it possible that something has changed on Azure Synapse Analytics last time about using where clause on datetime column in SQL? 

This sql code return only value '2023-01-02' but as i know it supposed to return '2023-01-02' and null value. 

with cnt as (
select cast(null as date) test_date
union
select '2023-01-02'
union 
select '2018-11-22'
)select * from cnt
where test_date > '2018-11-22'

Anyone knows? 

0 Replies