hubgeter opened a new pull request, #41049:
URL: https://github.com/apache/doris/pull/41049
bp #40695
## 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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
