maropu commented on a change in pull request #29538:
URL: https://github.com/apache/spark/pull/29538#discussion_r476214844
##########
File path: docs/sql-migration-guide.md
##########
@@ -189,6 +189,69 @@ license: |
- Since Spark 3.0, when using `EXTRACT` expression to extract the second
field from date/timestamp values, the result will be a `DecimalType(8, 6)`
value with 2 digits for second part, and 6 digits for the fractional part with
microsecond precision. e.g. `extract(second from to_timestamp('2019-09-20
10:10:10.1'))` results `10.100000`. In Spark version 2.4 and earlier, it
returns an `IntegerType` value and the result for the former example is `10`.
+ - In Spark 3.0, datetime pattern letter `F` represents the concept of the
count of days within the period of a week where the weeks are aligned to the
start of the month, e.g.
+ ```sql
+ SELECT d, date_format(d, 'F') AS f
Review comment:
Could we move the example queries into the datetime doc, then add a link
here to it? IMHO most users check the doc first, maybe...
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
