/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

2 votes114 views1 answer
Sql string starts with
SQL
15 votes221 views2 answers
Sql order by alphabetical
SQL
0 vote111 views1 answer
How to find unique element in sql
SQL
0 vote113 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote98 views1 answer
Sql last 7 days
SQL
0 vote93 views1 answer
Limiting query result using where in sql
SQL
-2 votes155 views1 answer
Trunc in sql
SQL
0 vote99 views1 answer
Mysql repair a table
SQL
0 vote106 views1 answer
Postgres declare variable
SQL
0 vote233 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL