<commit_before>### 日期函数

| Function Syntax                          | Decription                               | Example                               |
| ---------------------------------------- | ---------------------------------------- | ------------------------------------- |
| LOCALTIME                                | 返回当前时区的时间,返回类型为TIME格式                    | ```select LOCALTIME```                |
| LOCALTIMESTAMP                           | Returns the current date and time in the session time zone in a value of datatype TIMESTAMP  返回当前时区的日期时间，返回类型为TIMESTAMP | ```select LOCALTIMESTAMP```           |
| CURRENT_TIME                             | 返回当前时区的时间，返回类型为带时区的TIMESTAMP             | ```select CURRENT_TIME```             |
| CURRENT_DATE                             | DATE 返回当前时区的日期，返回类型为DATE                 | ```select CURRENT_DATE```             |
| CURRENT_TIMESTAMP                        | TIMESTAMP WITH TIME ZONE 返回当前时区的日期时间，返回类型为带时区的TIMESTAMP | ```select CURRENT_TIMESTAMP```        |
| EXTRACT(timeUnit FROM datetime)          | 提取返回日期中的指定日期项                            |                                       |
| FLOOR(datetime TO timeUnit)              | 以*timeUnit*为单位对*datetime*向下取整            |                                       |
| CEIL(datetime TO timeUnit)               | 以*timeUnit*为单位对*datetime*向上取整*           |                                       |
| YEAR(date)                               | 返回日期中的年份等同于EXTRACT(YEAR FROM date)，返回类型为integrer | ```select YEAR(CURRENT_DATE)```       |
| QUARTER(date)                            | Returns an integer between 1 and 4. 返回日期中的季度，返回值为1到4的整数，等同于 `EXTRACT(QUARTER FROM date)`. | ```select QUARTER(CURRENT_DATE)```    |
| MONTH(date)                              | 返回日期中的月份，返回值为1到12的整数，等同于`EXTRACT(MONTH FROM date)`. | ```select MONTH(CURRENT_DATE)```      |
| WEEK(date)                               | 返回日期中的星期是一年的第几个星期，返回值为1到53的整数，等同于```EXTRACT(WEEK FROM date)``` |                                       |
| DAYOFYEAR(date)                          | 返回日期是一年中的第几天，返回值为1到366的整数，等同于`EXTRACT(DOY FROM date)`. |                                       |
| DAYOFMONTH(date)                         | 返回日期是一月中的第几天，返回值为1到31，等同于```EXTRACT(DAY FROM date)``` | ```select DAYOFMONTH(CURRENT_DATE)``` |
| DAYOFWEEK(date)                          | 返回日期是星期几，返回值为1到7的整数，等同于`EXTRACT(DOW FROM date)`. |                                       |
| HOUR(date)                               | 返回日期中的小时数，返回值为0到23的整数，等同于 `EXTRACT(HOUR FROM date)`. | ```select HOUR(CURRENT_TIME)```       |
| MINUTE(date)                             | 返回日期中的分钟数，返回结果为0到59的整数，等同于`EXTRACT(MINUTE FROM date)` | ```select MINUTE(CURRENT_TIME)```     |
| SECOND(date)                             | 返回日期中的秒数，返回结果为0到59的整数，等同于`EXTRACT(SECOND FROM date)`. | ```select SECOND(CURRENT_TIME)```     |
| TIMESTAMPADD(timeUnit, integer, datetime) | 返回添加了*timeUnit*s为单位的时间integer后的日期*datetime*,返回类型为*datetime*,等同于`datetime + INTERVAL 'integer' timeUnit` |                                       |
| TIMESTAMPDIFF(timeUnit, datetime, datetime2) | 返回*datetime*后*datetime*的时间差，以timeUnit为单位返回，等同于`(datetime2 - datetime) timeUnit` |                                       |<commit_msg>add more example for date and time function (#241)<commit_after>### 日期函数

| Function Syntax                          | Decription                               | Example                                  |
| ---------------------------------------- | ---------------------------------------- | ---------------------------------------- |
| LOCALTIME                                | 返回当前时区的时间,返回类型为TIME格式                    | ```select LOCALTIME```                   |
| LOCALTIMESTAMP                           | Returns the current date and time in the session time zone in a value of datatype TIMESTAMP  返回当前时区的日期时间，返回类型为TIMESTAMP | ```select LOCALTIMESTAMP```              |
| CURRENT_TIME                             | 返回当前时区的时间，返回类型为带时区的TIMESTAMP             | ```select CURRENT_TIME```                |
| CURRENT_DATE                             | DATE 返回当前时区的日期，返回类型为DATE                 | ```select CURRENT_DATE```                |
| CURRENT_TIMESTAMP                        | TIMESTAMP WITH TIME ZONE 返回当前时区的日期时间，返回类型为带时区的TIMESTAMP | ```select CURRENT_TIMESTAMP```           |
| EXTRACT(timeUnit FROM datetime)          | 提取返回日期中的指定日期项。 timeunit处可以填写year、month、day、hour、minute、second. | `select EXTRACT(year FROM PART_DT) from KYLIN_SALES` |
| FLOOR(datetime TO timeUnit)              | 以*timeUnit*为单位对*datetime*向下取整。timeunit处可以填写year、month、day、hour、minute、second. |                                          |
| CEIL(datetime TO timeUnit)               | 以*timeUnit*为单位对*datetime*向上取整。timeunit处可以填写year、month、day、hour、minute、second. |                                          |
| YEAR(date)                               | 返回日期中的年份等同于EXTRACT(YEAR FROM date)，返回类型为integrer | ```select YEAR(CURRENT_DATE)```          |
| QUARTER(date)                            | Returns an integer between 1 and 4. 返回日期中的季度，返回值为1到4的整数，等同于 `EXTRACT(QUARTER FROM date)`. | ```select QUARTER(CURRENT_DATE)```       |
| MONTH(date)                              | 返回日期中的月份，返回值为1到12的整数，等同于`EXTRACT(MONTH FROM date)`. | ```select MONTH(CURRENT_DATE)```         |
| WEEK(date)                               | 返回日期中的星期是一年的第几个星期，返回值为1到53的整数，等同于```EXTRACT(WEEK FROM date)``` | `select week(PART_DT) from KYLIN_SALES`  |
| DAYOFYEAR(date)                          | 返回日期是一年中的第几天，返回值为1到366的整数，等同于`EXTRACT(DOY FROM date)`. | `select DAYOFYEAR(PART_DT) from KYLIN_SALES` |
| DAYOFMONTH(date)                         | 返回日期是一月中的第几天，返回值为1到31，等同于```EXTRACT(DAY FROM date)``` | ```select DAYOFMONTH(CURRENT_DATE)```    |
| DAYOFWEEK(date)                          | 返回日期是星期几，返回值为1到7的整数，等同于`EXTRACT(DOW FROM date)`. | `select DAYOFWEEK(PART_DT) from KYLIN_SALES` |
| HOUR(date)                               | 返回日期中的小时数，返回值为0到23的整数，等同于 `EXTRACT(HOUR FROM date)`. | ```select HOUR(CURRENT_TIME)```          |
| MINUTE(date)                             | 返回日期中的分钟数，返回结果为0到59的整数，等同于`EXTRACT(MINUTE FROM date)` | ```select MINUTE(CURRENT_TIME)```        |
| SECOND(date)                             | 返回日期中的秒数，返回结果为0到59的整数，等同于`EXTRACT(SECOND FROM date)`. | ```select SECOND(CURRENT_TIME)```        |
| TIMESTAMPADD(timeUnit, integer, datetime) | 返回添加了*timeUnit*s为单位的时间integer后的日期*datetime*,返回类型为*datetime*,等同于`datetime + INTERVAL 'integer' timeUnit` 。 如示例中的函数返回日期part_dt加一个月。 | `select TIMESTAMPADD(month, 1, PART_DT),PART_DT from KYLIN_SALES` |
| TIMESTAMPDIFF(timeUnit, datetime, datetime2) | 返回*datetime*和*datetime2*的时间差，以timeUnit为单位返回，等同于`(datetime2 - datetime) timeUnit` | `select TIMESTAMPDIFF(month, date'2012-01-01', date '2012-02-01')` |
{'fraction_non_alphanumeric': 0.1407341358299896, 'fraction_numerical': 0.012037449843958983, 'mean_word_length': 1.6258291065158017, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 27, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3822654', 'n_tokens_mistral': 2496, 'n_tokens_neox': 2474, 'n_words': 312}