[jira] [Updated] (BEAM-6000) Support DATETIME type in BeamSQL

["Andrew Pilloud (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/BEAM-6000?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrew Pilloud updated BEAM-6000:
---------------------------------
    Resolution: Duplicate
        Status: Resolved  (was: Open)

> 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: P3
>
> 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
(v8.3.4#803005)