You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by ts...@apache.org on 2015/05/12 07:56:50 UTC
[08/25] drill git commit: add openkb blog reference
add openkb blog reference
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/b65acbba
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/b65acbba
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/b65acbba
Branch: refs/heads/gh-pages
Commit: b65acbba2d332395757bd0d94fcdbaadd8167dc9
Parents: d7bc3a6
Author: Kristine Hahn <kh...@maprtech.com>
Authored: Fri May 8 10:52:57 2015 -0700
Committer: Kristine Hahn <kh...@maprtech.com>
Committed: Fri May 8 10:52:57 2015 -0700
----------------------------------------------------------------------
_docs/sql-reference/sql-functions/020-data-type-conversion.md | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/b65acbba/_docs/sql-reference/sql-functions/020-data-type-conversion.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-functions/020-data-type-conversion.md b/_docs/sql-reference/sql-functions/020-data-type-conversion.md
index 611d4cf..3ad20f7 100644
--- a/_docs/sql-reference/sql-functions/020-data-type-conversion.md
+++ b/_docs/sql-reference/sql-functions/020-data-type-conversion.md
@@ -714,9 +714,9 @@ Convert a UTC date to a timestamp offset from the UTC time zone code.
1 row selected (0.129 seconds)
## Time Zone Limitation
-Currently Drill does not support conversion of a date, time, or timestamp from one time zone to another. The workaround is to configure Drill to use [UTC](http://www.timeanddate.com/time/aboututc.html)-based time, convert your data to UTC timestamps, and perform date/time operation in UTC.
+Currently Drill does not support conversion of a date, time, or timestamp from one time zone to another. Queries of data associated with a time zone can return inconsistent results or an error. For more information, see the ["Understanding Drill's Timestamp and Timezone"](http://www.openkb.info/2015/05/understanding-drills-timestamp-and.html#.VUzhotpVhHw) blog. The Drill time zone is based on the operating system time zone unless you override it. To work around the limitation, configure Drill to use [UTC](http://www.timeanddate.com/time/aboututc.html)-based time, convert your data to UTC timestamps, and perform date/time operation in UTC.
-1. Take a look at the Drill time zone configuration by running the TIMEOFDAY function. This function returns the local date and time with time zone information.
+1. Take a look at the Drill time zone configuration by running the TIMEOFDAY function or by querying the system.options table. This TIMEOFDAY function returns the local date and time with time zone information.
SELECT TIMEOFDAY() FROM sys.version;