/SQL/How to declare variable date in mysql

How to declare variable date in mysql

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'  ;

Source: stackoverflow.com

Similar codes

0 vote123 views1 answer
Mysql query to select the highest value
SQL
2 votes110 views1 answer
Postgresql update sequence next value
SQL
0 vote115 views1 answer
Sql constarint
SQL
5 votes132 views6 answers
In operator sql
SQL
2 votes113 views1 answer
Q operator in plsql
SQL
0 vote123 views1 answer
Sql datediff month
SQL
7 votes116 views6 answers
Nth highest salary in sql
SQL
0 vote103 views1 answer
How to get employee having maximum experience in mysql
SQL
19 votes127 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
11 votes122 views2 answers
Safe mode off mysql
SQL