Hello,
I have a dataset containing a column of dates, which I want to use for
filtering. Nothing, from what I have tried, seems to return the exact right
solution.
Here's my input:
+------------ +
| Date |
+------------ +
| 02-08-2019 |
+------------ +
| 02-07-2019 |
+----------------+
| 12-01-2019 |
+----------------+
| 02-02-2015 |
+----------------+
| 02-03-2012 |
+----------------+
| 05-06-2018 |
+----------------+
| 02-08-2022 |
+----------------+
The code that i have tried (always giving missing dates in the result):
dataset = dataset.filter( dataset.col("Date").geq("02-03-2012")); // not
> showing the date of *02-02-2015*
I tried to apply *date_trunc()* with the first parameter "day" but nothing.
I have also compared a converted column (using *to_date()*) with a
*literal *of the target date but always returning an empty dataset.
How to do that in Java ?
