You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2018/12/18 01:17:04 UTC
[drill] branch gh-pages updated: edit to format description MD-5253
This is an automated email from the ASF dual-hosted git repository.
bridgetb pushed a commit to branch gh-pages
in repository https://gitbox.apache.org/repos/asf/drill.git
The following commit(s) were added to refs/heads/gh-pages by this push:
new 6d9ff30 edit to format description MD-5253
6d9ff30 is described below
commit 6d9ff30c1655f1c787f89b8a151f44a0da636cce
Author: Bridget Bevens <bb...@maprtech.com>
AuthorDate: Mon Dec 17 17:16:16 2018 -0800
edit to format description MD-5253
---
_docs/sql-reference/sql-functions/020-data-type-conversion.md | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
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 21dcf3e..336dcaa 100644
--- a/_docs/sql-reference/sql-functions/020-data-type-conversion.md
+++ b/_docs/sql-reference/sql-functions/020-data-type-conversion.md
@@ -1,6 +1,6 @@
---
title: "Data Type Conversion"
-date: 2018-06-27 20:53:00 UTC
+date: 2018-12-18
parent: "SQL Functions"
---
Drill supports the following functions for casting and converting data types:
@@ -686,7 +686,7 @@ Converts a character string or a UNIX epoch timestamp to a date.
*expression* is a character string enclosed in single quotation marks or a Unix epoch timestamp in milliseconds, not enclosed in single quotation marks.
-*'format'* is a format specifier enclosed in single quotation marks that sets a pattern for the output formatting. Use this option only when the expression is a character string, not a UNIX epoch timestamp.
+*'format'* is a character string that specifies the format of 'expression'. Only use this option when the expression is a character string, not a UNIX epoch timestamp.
### TO_DATE Usage Notes
Specify a format using patterns defined in [Joda DateTimeFormat class](http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html). The TO_TIMESTAMP function takes a Unix epoch timestamp. The TO_DATE function takes a UNIX epoch timestamp in milliseconds. The [UNIX_TIMESTAMP]({{site.baseurl}}/docs/date-time-functions-and-arithmetic/#unix_timestamp) function converts a time string to a UNIX timestamp in seconds.
@@ -849,7 +849,7 @@ Convert 828550000 milliseconds (23 hours 55 seconds) to the time.
*expression* is a character string enclosed in single quotation marks or a UNIX epoch timestamp, not enclosed in single quotation marks.
-*'format'* is a format specifier enclosed in single quotation marks that sets a pattern for the output formatting. Use this option only when the expression is a character string, not a UNIX epoch timestamp.
+*'format'* is a character string that specifies the format of 'expression'. Only use this option when the expression is a character string, not a UNIX epoch timestamp.
### TO_TIMESTAMP Usage Notes
Specify a format using patterns defined in [Joda DateTimeFormat class](http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html). The TO_TIMESTAMP function takes a Unix epoch timestamp. The TO_DATE function takes a UNIX epoch timestamp in milliseconds.