date format in Flink SQL

[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?

[Timo Walther]

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?