[
https://issues.apache.org/jira/browse/BEAM-6000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rui Wang reassigned BEAM-6000:
------------------------------
Assignee: (was: Rui Wang)
> Support DATETIME type in BeamSQL
> --------------------------------
>
> Key: BEAM-6000
> URL: https://issues.apache.org/jira/browse/BEAM-6000
> Project: Beam
> Issue Type: New Feature
> Components: dsl-sql
> Reporter: Rui Wang
> Priority: Major
>
> Datetime type
> Name Description Range
> DATETIME Represents a year, month, day, hour, minute, second, and
> subsecond. 0001-01-01 00:00:00 to 9999-12-31 23:59:59.999999.
> A DATETIME represents a point in time. Each DATETIME contains the following:
> year
> month
> day
> hour
> minute
> second
> subsecond
> Unlike Timestamps, a DATETIME object does not refer to an absolute instance
> in time. Instead, it is the civil time, or the time that a user would see on
> a watch or calendar.
> Canonical format
> YYYY-[M]M-[D]D[( |T)[H]H:[M]M:[S]S[.DDDDDD]]
> YYYY: Four-digit year
> [M]M: One or two digit month
> [D]D: One or two digit day
> ( |T): A space or a T separator
> [H]H: One or two digit hour (valid values from 00 to 23)
> [M]M: One or two digit minutes (valid values from 00 to 59)
> [S]S: One or two digit seconds (valid values from 00 to 59)
> [.DDDDDD]: Up to six fractional digits (i.e. up to microsecond precision)
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
