Hi Soheil,
the functions for date/time conversion are pretty limited so far. The
full list of supported functions can be found here [1]. If you need more
(which is usually the case), it is easy to implement a custom function [2].
We rely on Java's java.sql.Date as a data type. You can use `SELECT DATE
'2018-09-23'` to create literals.
I hope this helps.
Regards,
Timo
[1]
https://ci.apache.org/projects/flink/flink-docs-release-1.7/dev/table/functions.html
[2]
https://ci.apache.org/projects/flink/flink-docs-release-1.7/dev/table/udfs.html#scalar-functions
Am 29.01.19 um 09:42 schrieb Soheil Pourbafrani:
Hi,
I want to convert a string in the format of 1996-8-01 to date and
create Table from the dataset of Tuple3<String, Date, Integer> at the
end. Since I want to apply SQL queries on the date field of the table,
for example, "date_column < 1996-8-01", which java format of date is
supported in Flink?
