[jira] [Commented] (FLINK-2961) Add support for basic type Date in Table API

[ASF GitHub Bot (JIRA)]

    [ 
https://issues.apache.org/jira/browse/FLINK-2961?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16193603#comment-16193603
 ] 

ASF GitHub Bot commented on FLINK-2961:
---------------------------------------

Github user coveralls commented on the issue:

    https://github.com/apache/flink/pull/1322
  
    
    [![Coverage 
Status](https://coveralls.io/builds/13591448/badge)](https://coveralls.io/builds/13591448)
    
    Changes Unknown when pulling **2544011784017fc188882234fe38ebf6b3c58b84 on 
twalthr:TableApiDate** into ** on apache:master**.



> 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 & SQL
>            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.4.14#64029)