Rui Wang created BEAM-6000:
------------------------------
Summary: 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
Assignee: Rui Wang
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)
