Timo Walther created FLINK-2961:
-----------------------------------
Summary: Add support for basic type Date in Table API
Key: FLINK-2961
URL: https://issues.apache.org/jira/browse/FLINK-2961
Project: Flink
Issue Type: Improvement
Components: Table API
Reporter: Timo Walther
Assignee: Timo Walther
Priority: Minor
Currently, the basic type {{Date}} is not implemented in the Table API. In
order to have a mapping of the most important ANSI SQL types for FLINK-2099. It
makes sense to add support for {{Date}} to represent date, time and timestamps
of milliseconds precision.
Only the types `LONG` and `STRING` can be casted to `DATE` and vice versa. A
`LONG` casted to `DATE` must be a milliseconds timestamp. A `STRING` casted to
`DATE` must have the format "`yyyy-MM-dd HH:mm:ss.SSS`", "`yyyy-MM-dd`",
"`HH:mm:ss`", or a milliseconds timestamp. All timestamps refer to the UTC
timezone beginning from January 1, 1970, 00:00:00 in milliseconds.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
