片寄と申します。

CAST()の使用目的がわかりません。
必要なのでしょうか？

SELECT * FROM hiduke_tb WHERE hiduke >= CAST('2006-06-01' AS date)
SELECT * FROM hiduke_tb WHERE hiduke >= CAST('2006-06-1' AS date)
SELECT * FROM hiduke_tb WHERE hiduke >= CAST('2006-6-1' AS date)

であるなら、ちょっとは理解できますが


片寄

Akimasa wrote:
> 初めまして、大月と申します。
> 
 
> mysql> SELECT * FROM hiduke_tb WHERE hiduke >=
> 2006-6-1';  ------------------(1)
> +------------+
> | hiduke     |
> +------------+
> | 2006-06-01 |
> | 2006-06-10 |
> +------------+
> 2 rows in set (0.00 sec)
> 
> mysql> SELECT * FROM hiduke_tb WHERE CAST(hiduke AS date) >=
> 2006-6-1';  ----(2)
> Empty set (0.00 sec)
> 
> mysql> SELECT * FROM hiduke_tb WHERE CAST(hiduke AS date) >=
> 2006-06-1';  ---(3)
> +------------+
> | hiduke     |
> +------------+
> | 2006-06-10 |
> +------------+
> 1 row in set (0.00 sec)
> 
> mysql> SELECT * FROM hiduke_tb WHERE CAST(hiduke AS date) >=
> 2006-06-01';  --(4)
> +------------+
> | hiduke     |
> +------------+
> | 2006-06-01 |
> | 2006-06-10 |
> +------------+
> 2 rows in set (0.00 sec)
> 
> ※(2)(3)(4)は、わざと日付型から日付型にCASTしています