@ohadravid 5.2 4.5.11 (2018-08-21) 5.2.1 Improvements • resolve #7672 compatibility with ruamel.yaml 0.15.54 (#7675) 5.2.2 Contributors • @CJ-Wright • @mbargull 5.3 4.5.10 (2018-08-13) 5.3.1 Bug Fixes • fix #6748 only warn if unable to register environment due to EACCES (#6752) 5.18 4.4.7 (2018-01-08) 5.18.1 Improvements • resolve #6650 add upgrade message for unicode errors in python 2 (#6651) (#6654) • fix #6659 conda list explicit should be dependency sorted (#6671) 5.18. 4.4.7 (2018-01-08) 109 conda Documentation, Release 4.6.0 • fix #6665 KeyError for channel ‘’ (#6668, #6673)

@ohadravid 5.2 4.5.11 (2018-08-21) 5.2.1 Improvements • resolve #7672 compatibility with ruamel.yaml 0.15.54 (#7675) 5.2.2 Contributors • @CJ-Wright • @mbargull 5.3 4.5.10 (2018-08-13) 5.3.1 Bug Fixes • fix #6748 only warn if unable to register environment due to EACCES (#6752) 5.18 4.4.7 (2018-01-08) 5.18.1 Improvements • resolve #6650 add upgrade message for unicode errors in python 2 (#6651) (#6654) • fix #6659 conda list explicit should be dependency sorted (#6671) 5.18. 4.4.7 (2018-01-08) 109 conda Documentation, Release 4.6.1 • fix #6665 KeyError for channel ‘’ (#6668, #6673)

https://github.com/conda/conda/pull/11816 • @travishathaway • @pre-commit-ci[bot] 7.7 4.14.0 (2022-08-02) 7.7.1 Enhancements • Only star activated environment in conda info --envs/conda env list. (#10764) OrderedDict. (#11649) • Mark conda.another_to_unicode as pending deprecation. (#11678) 7.7. 4.14.0 (2022-08-02) 239 conda Documentation, Release 23.3.1.post2+bdcba5dd0 7.7.4 Docs • Corresponding documentation @travishathaway made their first contribution in #11373 • @pre-commit-ci[bot] 7.9 4.12.0 (2022-03-08) 7.9.1 Enhancements • Add support for libmamba integrations. (#11193) This is a new experimental

100,'2023-08-31 09:10:11','2023-08-31 �→ 09:10:11'),(2,200,200,'2023-08-31 09:10:11','2023-08-31 09:10:11') �→ ,(3,300,300,'2023-08-31 09:10:11','2023-08-31 09:10:11') �→ ,(4,400,400,'2023-08-31 09:10:11' 09:10:11','2023-08-31 09:10:11') �→ ,(5,500,500,'2023-08-31 09:10:11','2023-08-31 09:10:11'); Executing (default): SELECT `id`, `coins`, `goods`, `createdAt`, `updatedAt` �→ FROM `players` AS `players` WHERE AS OF TIMESTAMP TIDB_BOUNDED_STALENESS('2016-10-08 16:45:26', '2016-10-08 �→ 16:45:29') queries the latest data between 2016-10-08 16:45:26 and 2016-10-08 16:45:29. • AS OF TIMESTAMP TIDB_BOUNDED_STAL

100,'2023-08-31 09:10:11','2023-08-31 �→ 09:10:11'),(2,200,200,'2023-08-31 09:10:11','2023-08-31 09:10:11') �→ ,(3,300,300,'2023-08-31 09:10:11','2023-08-31 09:10:11') �→ ,(4,400,400,'2023-08-31 09:10:11' 09:10:11','2023-08-31 09:10:11') �→ ,(5,500,500,'2023-08-31 09:10:11','2023-08-31 09:10:11'); Executing (default): SELECT `id`, `coins`, `goods`, `createdAt`, `updatedAt` �→ FROM `players` AS `players` WHERE AS OF TIMESTAMP TIDB_BOUNDED_STALENESS('2016-10-08 16:45:26', '2016-10-08 �→ 16:45:29') queries the latest data between 2016-10-08 16:45:26 and 2016-10-08 16:45:29. • AS OF TIMESTAMP TIDB_BOUNDED_STAL

100,'2023-08-31 09:10:11','2023-08-31 �→ 09:10:11'),(2,200,200,'2023-08-31 09:10:11','2023-08-31 09:10:11') �→ ,(3,300,300,'2023-08-31 09:10:11','2023-08-31 09:10:11') �→ ,(4,400,400,'2023-08-31 09:10:11' 09:10:11','2023-08-31 09:10:11') �→ ,(5,500,500,'2023-08-31 09:10:11','2023-08-31 09:10:11'); Executing (default): SELECT `id`, `coins`, `goods`, `createdAt`, `updatedAt` �→ FROM `players` AS `players` WHERE AS OF TIMESTAMP TIDB_BOUNDED_STALENESS('2016-10-08 16:45:26', '2016-10-08 �→ 16:45:29') queries the latest data between 2016-10-08 16:45:26 and 2016-10-08 16:45:29. • AS OF TIMESTAMP TIDB_BOUNDED_STAL

100,'2023-08-31 09:10:11','2023-08-31 �→ 09:10:11'),(2,200,200,'2023-08-31 09:10:11','2023-08-31 09:10:11') �→ ,(3,300,300,'2023-08-31 09:10:11','2023-08-31 09:10:11') �→ ,(4,400,400,'2023-08-31 09:10:11' 09:10:11','2023-08-31 09:10:11') �→ ,(5,500,500,'2023-08-31 09:10:11','2023-08-31 09:10:11'); Executing (default): SELECT `id`, `coins`, `goods`, `createdAt`, `updatedAt` �→ FROM `players` AS `players` WHERE AS OF TIMESTAMP TIDB_BOUNDED_STALENESS('2016-10-08 16:45:26', '2016-10-08 �→ 16:45:29') queries the latest data between 2016-10-08 16:45:26 and 2016-10-08 16:45:29. • AS OF TIMESTAMP TIDB_BOUNDED_STAL

100,'2023-08-31 09:10:11','2023-08-31 �→ 09:10:11'),(2,200,200,'2023-08-31 09:10:11','2023-08-31 09:10:11') �→ ,(3,300,300,'2023-08-31 09:10:11','2023-08-31 09:10:11') �→ ,(4,400,400,'2023-08-31 09:10:11' 09:10:11','2023-08-31 09:10:11') �→ ,(5,500,500,'2023-08-31 09:10:11','2023-08-31 09:10:11'); Executing (default): SELECT `id`, `coins`, `goods`, `createdAt`, `updatedAt` �→ FROM `players` AS `players` WHERE AS OF TIMESTAMP TIDB_BOUNDED_STALENESS('2016-10-08 16:45:26', '2016-10-08 �→ 16:45:29') queries the latest data between 2016-10-08 16:45:26 and 2016-10-08 16:45:29. • AS OF TIMESTAMP TIDB_BOUNDED_STAL

期望一个 Date 的时候，它会把 '2017-08-24' ， '20170824' ， 20170824 当做是 Date。 TiDB 的 Date 值有以下几种格式： 'YYYY-MM-DD' 或者 'YY-MM-DD' ，这里的 - 分隔符并不是严格的，可以是任意的标点符号。比如 '2017- 08-24' ， '2017&08&24' ， '2012@12^31' 都是一样的。唯一需要特别对待的是 '170824104520' 被当做是 '2017-08- 24 10:45:20' ，但是如果你提供了一个超过范围的值，例如 '170824304520' ，那这就不是一个有效的 Date 字 面值。 YYYYMMDDHHMMSS 或者 YYMMDDHHMMSS 注意这里没有单引号或者双引号，是一个数字。例如 20170824104520 表 示为 '2017-08-24 10:45:20' 。 DATETIME 范围，那么被转换成 2000-2069 。 对于小于 10 的 month 或者 day 值， '2017-8-4' 跟 '2017-08-04' 是一样的。对于 Time 也是一样，比 如 '2017-08-24 1:2:3' 跟 '2017-08-24 01:02:03' 是一样的。 在需要 Date 或者 Time 的语境下, 对于数值，TiDB 会根据数值的长度来选定指定的格式：