回答編集履歴

1

文字列じゃなかった・・・

2017/06/12 03:16

投稿

shi_ue
shi_ue

スコア4437

test CHANGED
@@ -4,9 +4,9 @@
4
4
 
5
5
  SELECT *,
6
6
 
7
- DATE(CONCAT(start_year, start_month, start_day)) AS start_date,
7
+ DATE(CONCAT_WS('-', start_year, start_month, start_day)) AS start_date,
8
8
 
9
- DATE(CONCAT(end_year, end_month, end_day)) AS end_date
9
+ DATE(CONCAT_WS('-', end_year, end_month, end_day)) AS end_date
10
10
 
11
11
  FROM テーブル名
12
12