|
Hybrid functions IF, IFNULL,CASE,COALESCE do not add
CURRENT_TIME when converting TIME to DATETIME:
mysql> SELECT IF(1,TIME'10:10:10',DATE'2001-01-01');
|
+---------------------------------------+
|
| IF(1,TIME'10:10:10',DATE'2001-01-01') |
|
+---------------------------------------+
|
| 0000-00-00 10:10:10 |
|
+---------------------------------------+
|
1 row in set (0.01 sec)
|
MySQL-5.6 correctly adds CURRENT_DATE:
+---------------------------------------+
|
| IF(1,TIME'10:10:10',DATE'2001-01-01') |
|
+---------------------------------------+
|
| 2014-04-15 10:10:10 |
|
+---------------------------------------+
|
1 row in set (0.00 sec)
|
|