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;
