drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tshi...@apache.org
Subject [08/25] drill git commit: add openkb blog reference
Date Tue, 12 May 2015 05:56:50 GMT
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 <khahn@maprtech.com>
Authored: Fri May 8 10:52:57 2015 -0700
Committer: Kristine Hahn <khahn@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;
 


Mime
View raw message