mysql> SELECT CAST(DATE'2001-01-01' AS TIME);
|
+--------------------------------+
|
| CAST(DATE'2001-01-01' AS TIME) |
|
+--------------------------------+
|
| 00:00:00 |
|
+--------------------------------+
|
1 row in set (0.00 sec)
|
|
mysql> DROP PROCEDURE IF EXISTS p1;
|
Query OK, 0 rows affected (0.02 sec)
|
|
mysql> DELIMITER |;
|
mysql> create procedure p1()
|
-> begin
|
-> declare t date;
|
-> set t=date'2001-01-01';
|
-> select cast(t as time);
|
-> end|;
|
Query OK, 0 rows affected (0.04 sec)
|
|
mysql> CALL p1|;
|
+-----------------+
|
| cast(t as time) |
|
+-----------------+
|
| 00:20:01 |
|
+-----------------+
|
1 row in set (0.00 sec)
|
|
Query OK, 0 rows affected, 1 warning (0.00 sec)
|