trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dbirds...@apache.org
Subject [2/3] incubator-trafodion git commit: Incorporate Comments 1
Date Sun, 26 Nov 2017 21:53:06 GMT
Incorporate Comments 1


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/7b428411
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/7b428411
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/7b428411

Branch: refs/heads/master
Commit: 7b428411c3a3e2d771a29c416670a597a73b9cd6
Parents: 1df5707
Author: liu.yu <yu.liu@esgyn.cn>
Authored: Thu Nov 23 11:52:59 2017 +0800
Committer: liu.yu <yu.liu@esgyn.cn>
Committed: Thu Nov 23 11:52:59 2017 +0800

----------------------------------------------------------------------
 .../sql_functions_and_expressions.adoc          | 20 ++++++++++----------
 1 file changed, 10 insertions(+), 10 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/7b428411/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
----------------------------------------------------------------------
diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
index 2927f75..d111292 100644
--- a/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
+++ b/docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
@@ -2312,7 +2312,7 @@ DATEDIFF (datepart, startdate, enddate)
 * `datepart`
 +
 is YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, QUARTER, WEEK, or one of the
-following abbreviations, should be enclosed in quotation marks:
+following abbreviations:
 +
 [cols="15%,85%"]
 |===
@@ -2354,7 +2354,7 @@ For example:
 However, the DATEDIFF difference is 1 minute, 1 hour, 1 day, 0 week^1^, 1 month, 1 quarter
or 1 month depending on the specified _datepart_.
 
 +
-^1^ NOTE: 2017-12-31 (_startdate_) falls on Sunday which cannot be counted. For more information,
see <<the_first_day_of_week,The first day of week>>.
+^1^ NOTE: 2017-12-31 (_startdate_) falls on a Sunday, which is in the same week as 2018-01-01.
For more information, see <<the_first_day_of_week,The first day of week>>.
 
 * Likewise, the difference between 2017-01-01 and 2018-12-31 is almost two years.
 
@@ -2364,9 +2364,9 @@ However, the DATEDIFF difference is 1 year if the specified _datepart_
is YEAR.
 [[the_first_day_of_week]]
 ==== The first day of week
 
-* This value cannot be specified, the default value is Sunday.
+* The first day of the week is Sunday. Changing the first day of the week is not supported.
 
-* The DATEDIFF function returns the number of Sundays between _startdate_ and _enddate_.
This function counts _enddate_ if it falls on Sunday, but doesn't count _startdate_ even if
it does fall on a Sunday.
+* The DATEDIFF function returns the number of Sundays between _startdate_ and _enddate_.
This function counts _enddate_ if it falls on a Sunday, but doesn't count _startdate_ even
if it does fall on a Sunday.
 
 +
 For example,
@@ -2378,7 +2378,7 @@ For example,
 [[the_first_week_of_year]]
 ==== The first week of year
 
-This value cannot be specified, the default value is the week in which Jan 1 occurs.  
+The first week of the year is the week in which January 1 occurs. Changing the first week
of the year is not supported.  
 
 [[negative_or_zero]]
 ==== Negative or zero
@@ -2392,7 +2392,7 @@ If _enddate_ precedes _startdate_, the return value is negative or zero.
 
 ** For seconds, the maximum number is equivalent to approximately 68 years. 
 
-** For weeks, if a difference in weeks is requested, one of the two dates cannot precede
0001-01-07.
+** For weeks, the dates must be later than 0001-01-07.
 
 <<<
 [[examples_of_datediff]]
@@ -2412,7 +2412,7 @@ SELECT DATEDIFF( SECOND
 FROM DUAL;
 ```
 
-* This function returns the value 1 because a one-second boundary is
+* This function returns the value of 1 because a one-second boundary is
 crossed even though the two timestamps differ by only one microsecond.
 +
 ```
@@ -2426,7 +2426,7 @@ FROM DUAL;
 [[date_difference_in_minute]]
 ==== Date Difference in MINUTE
 
-* This function returns the value of 2 because a two-minute boundary is crossed.
+* This function returns the value of 2 because two minute boundaries are crossed.
 +
 ```
 SELECT DATEDIFF( MINUTE
@@ -2449,7 +2449,7 @@ SELECT DATEDIFF( DAY
 FROM DUAL;
 ```
 
-* This statement calculates how long do buyers have to wait. 
+* This statement calculates how long buyers have to wait. 
 +
 ```
 SELECT id, DATEDIFF( DAY, order_date, delivery_date ), price 
@@ -2496,7 +2496,7 @@ FROM DUAL;
 [[date_difference_in_quarter]]
 ==== Date Difference in QUARTER
 
-* This function returns the value of 3 because a three-quarter boundary is crossed.
+* This function returns the value of 3 because three quarter boundaries are crossed.
 +
 ```
 SELECT DATEDIFF( QUARTER


Mime
View raw message