[MDEV-25489] Gestion numero semaine Created: 2021-04-22  Updated: 2021-04-22

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.3.24
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: youyou Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Synology DSM 6


 Description   

Il existe un pb dans la gestion des numéros de semaine.

DATE_FORMAT(2020-12-31 22:00:04,'%y%v') return 2053 => CORRECT
DATE_FORMAT(2021-01-01 00:00:03,'%y%v') return 2153 => INCORRECT

 Comments   
Comment by Alice Sherepa [ 2021-04-22 ]

please explain why do you consider it is a bug. (http://www.whatweekisit.org/calendar-2021.html)

MariaDB [test]> select DATE_FORMAT('2021-01-03','%y%v');
 
+----------------------------------+
 
| DATE_FORMAT('2021-01-03','%y%v') |
 
+----------------------------------+
 
| 2153                             |
 
+----------------------------------+
 
1 row in set (0.000 sec)
 
 
 
MariaDB [test]> select DATE_FORMAT('2021-01-04','%y%v');
 
+----------------------------------+
 
| DATE_FORMAT('2021-01-04','%y%v') |
 
+----------------------------------+
 
| 2101                             |
 
+----------------------------------+
 
1 row in set (0.000 sec)

Generated at Thu Feb 08 09:38:04 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.