cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Bug Report: Date type with year less than 1000 (years 1-999) in spark sql where [solved]

Kotofosonline
New Contributor III

Hi, I noticed unexpected behavior for Date type. If year value is less then 1000 then filtering do not work.

Steps:

create table test (date Date); insert into test values ('0001-01-01'); select * from test where date = '0001-01-01'

Returns 0 rows. Expected 1 row.

Comparison operators is also problematic

1 REPLY 1

Kotofosonline
New Contributor III

Hm, seems to work now.

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.