Incompatible issues about date and time functions

[qw4990]

Historical

• Function str_to_date is incompatible with Mysql #9666 @qw4990 types: fix incompatible issue for builtin function str_to_date #9693 cherry-picked
• Function date_add and date_sub don't check datetime field overflow #9667 @qw4990 expression: fix issue that date_add and date_sub is incompatible with MySQL #9702 cherry-picked
• Variable default_week_format doesn't work #9669 @zyycj expression: fix week func format #9685 cherry-picked
• Results of unix_timestamp()-unix_timestamp(now()) is wrong and not stable #9710 @qw4990 expression: fix issue that results of unix_timestamp()-unix_timestamp(now()) is wrong and not stable #9884 cherry-picked
• Results of select now()-curdate()*1000000-curtime() is not stable #9711 @qw4990 expression: fix issue that results of unix_timestamp()-unix_timestamp(now()) is wrong and not stable #9884 cherry-picked
• Function dayname is incompatible with Mysql #9713 @qw4990 expression: fix issue that function dayname is incompatible with Mysql when doing arithmetic #9975 cherry-picked
• date_add and date_sub are incompatible with Mysql #9715 @b41sh types: refine the parsing logic of INTERVAL to correct DATE_ADD/DATE_SUB #9874 cherry-picked
• addition between datetime and interval is not compatible with Mysql #9727 @erjiaqing expression: addition between datetime and interval is not compatible with Mysql #10329 cherry-picked
• dayofmonth month quarter and year are not compatible with Mysql #9728 @WangXiangUSTC types: extract month support 0 #10116 cherry-picked
• unix_timestamp is not compatible with Mysql #9729 @wjhuang2016 expression: fix unix_timestamp function which is not compatible with Mysql  #9751 WON'T FIX
• timestampadd is not compatible with Mysql #9730 @qw4990 expression: fix issue that timestampadd is not compatible with Mysql #10314 cherry-picked
• last_day is not compatible with Mysql #9731 @wjhuang2016 expression: fix last_day function #9746 expression: fix last_day function #9750
• monthname is not compatible with Mysql #9732 @qw4990 expression: fix issue that monthname is not compatible with Mysql  #10109 cherry-picked
• selection between dates is not compatible with Mysql #9734 @WangXiangUSTC types: fix incorrect time fraction parsing method #9933 cherry-picked
• MAKETIME is not compatible with Mysql #9735 @AndrewDi expression: handle maketime unsigned hour overflow #10074 cherry-picked
• PERIOD_ADD is not compatible with Mysql #9736 @qw4990 expression: check if period is valid in period_add #10380 cherry-picked
• Wrong DATE/DATETIME comparison in BETWEEN function #9764 @erjiaqing planner: fix wrong DATE/DATETIME comparison in BETWEEN function #10313 cherry-picked
• Handling invalid YEAR string is not compatible with Mysql #9767 @b41sh fix invalid YEAR string is not compatible with Mysql #9856 cherry-picked
• Cast date error #9769 @qw4990 expression: fix cast(-num as datetime) to return null instead of error #10368 cherry-picked
• Converting decimal to datetime or timestamp when insert is not compatible with MySQL #9770 @Debiancc types: fix converting decimal to datetime and timestamp #9899 cherry-picked
• str_to_date is not compatible with MySQL #9773 @b41sh fix str_to_date func compatible issues 9773 #9819 cherry-picked
• TIME_FORMAT is not compatible with MySQL #9774 @lzmhhh123 types: fix time_format is not compatible with MySQL. #9841 cherry-picked
• set time_zone is not compatible with MySQL #9775 @WangXiangUSTC sessionctx: add time zone check #9822 cherry-picked
• expression: unix_timestamp is not compatible with MySQL #10051 WON'T FIX
• convert_tz is not compatible with MySQL #9776 INVALID
• addition between datetime and real interval is not compatible with Mysql #10346 @erjiaqing expression: addition between datetime and real interval is not compatible with Mysql #10347 cherry-picked
• unix_timestamp is not compatible with MySQL #10361 @qw4990 expression: fix cast(-num as datetime) to return null instead of error #10368 cherry-picked
• date_add/date_sub can return mysql.Time. #9813 @winoros *: add_date can return mysql.Time #9830 cherry-picked
• Function period_diff is not compatible with MySQL 8.0 #10382 @mantuliu expression: fix issue that period_diff is not compatible with MySQL 8.0 #10383 cherry-picked
• Null datetime is not compatible with MySQL #9763 @qw4990 expression: fix issue that TimeIsNull is not compatible with MySQL  #10753

[together-wang]

#10504

[ti-srebot]

Please edit this comment or add a new comment to complete the following information

Not a bug

1. Remove the 'type/bug' label
2. Add notes to indicate why it is not a bug

Duplicate bug

1. Add the 'type/duplicate' label
2. Add the link to the original bug

Bug

Note: Make Sure that 'component', and 'severity' labels are added
Example for how to fill out the template: #20100

1. Root Cause Analysis (RCA) (optional)

2. Symptom (optional)

3. All Trigger Conditions (optional)

4. Workaround (optional)

5. Affected versions

6. Fixed versions