Hi All, I have a date which is stored as string and we would like to query it in Impala using greater than or less than functionality , however i am having no luck and when i play around unixtimestamp/timestamp it returns as Null values. e.g. select * from table T1 where orderdate is less than < 1/1/2001 order date is stored as string in T1 and doesnot have padded zeroes : 1/1/2001 (and not 01/01/2001)   SELECT cast(unix_timestamp(`date`, "MM/dd/yyyy") as timestamp), `date` FROM T1 ;  Result --  Null values for cast command   SELECT * FROM T1 WHERE start = '"4/3/2015"' ; Result - No data   SELECT * FROM T1 WHERE start > "4/3/2015" ; Result - No data     ... View more