mysql 声明时间变量_MYSQL如何声明一个datetime变量？

我的代码：

DECLARE report_date DATETIME;

set report_date='2013-01-17 00:00:00';

SELECT *

FROM `NMPP`.`capacitypersecond`

WHERE `StreamDT` >=report_date and `StreamDT` < '2013-01-18 00:00:00' ;

SELECT *

FROM `NMPP`.`capacityperHr`

WHERE `StreamDT` >=report_date and `StreamDT` < '2013-01-18 00:00:00' ;

SELECT *

FROM `NMPP`.`capacityperDay`

WHERE `TJLDate` >=report_date and `TJLDate` < '2013-01-18 00:00:00' ;

–

DECLARE report_date DATETIME;

/* SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE report_date DATETIME' at line 1 */

/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 0 of 5 queries: 0.000 sec. */