[ https://issues.apache.org/jira/browse/FLINK-2961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Timo Walther resolved FLINK-2961. --------------------------------- Resolution: Fixed Fix Version/s: 1.0.0 Fixed in 31a2de86d9034def9c58ef7f3d3dcae3d4dafd6f. > 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 > Fix For: 1.0.0 > > > 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)