hubgeter opened a new pull request, #41600:
URL: https://github.com/apache/doris/pull/41600
bp #40695 and #41075
#41075 : fix #40695 mac compile
## Proposed changes
Added three functions: `normal_cdf`, `to_iso8601`, `from_iso8601_date`
1. `normal_cdf(mean, sd, v) → double` :
Compute the Normal cdf with given mean and standard deviation (sd): P(N <
value; mean, sd). The mean and value must be real values and the standard
deviation must be a real and positive value (all of type DOUBLE).
2. `to_iso8601(DATE/DATETIME) → string`
For `DATE` type, it will be converted to `YYYY-MM-DD`.
For `DATETIME` type, it will be converted to `YYYY-MM-DDThh:mm:ss.xxxxxx`.
3. `from_iso8601_date(string) → DATE`
Convert iso8601 string to `DATE` type.
The supported iso8601 string formats are as follows:
a. Year : YYYY
b. Calendar dates : YYYY-MM-DD , YYYYMMDD , YYYY-MM
c. Week dates : YYYY-Www , YYYYWww , YYYY-Www-D , YYYYWwwD
d. Ordinal dates : YYYY-DDD , YYYYDDD
You can refer to this [document](https://en.wikipedia.org/wiki/ISO_8601) to
understand what these formats mean
Please note that:
a. Each date and time value has a fixed number of digits that must be
padded with leading zeros.
b. The range of YYYY is 0001-9999.
outside these rules, the correctness of the results is not guaranteed.
For illegal values, the result is NULL.
--
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.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
