1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
| --------------
set @date_1 = "2017"
--------------
--------------
set @date_2 = "04/2017"
--------------
--------------
set @date_3 = "17/04/2017"
--------------
--------------
select str_to_date(right(concat("01/01/", @date_1), 10), "%d/%m/%Y")
--------------
+---------------------------------------------------------------+
| str_to_date(right(concat("01/01/", @date_1), 10), "%d/%m/%Y") |
+---------------------------------------------------------------+
| 2017-01-01 |
+---------------------------------------------------------------+
--------------
select str_to_date(right(concat("01/01/", @date_2), 10), "%d/%m/%Y")
--------------
+---------------------------------------------------------------+
| str_to_date(right(concat("01/01/", @date_2), 10), "%d/%m/%Y") |
+---------------------------------------------------------------+
| 2017-04-01 |
+---------------------------------------------------------------+
--------------
select str_to_date(right(concat("01/01/", @date_3), 10), "%d/%m/%Y")
--------------
+---------------------------------------------------------------+
| str_to_date(right(concat("01/01/", @date_3), 10), "%d/%m/%Y") |
+---------------------------------------------------------------+
| 2017-04-17 |
+---------------------------------------------------------------+
Appuyez sur une touche pour continuer... |
Partager