/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 vote187 views1 answer
Concat column value of same user in mysql
SQL
5 votes200 views1 answer
Sqlite alter table add column
SQL
1 vote187 views1 answer
Postgres cast as currency format
SQL
0 vote186 views1 answer
Myswql show full processlist
SQL
0 vote196 views1 answer
Load utilities in sql server
SQL
0 vote207 views1 answer
Left join vs inner join performance
SQL
0 vote195 views2 answers
Sql 2 way of select unique
SQL
0 vote248 views1 answer
Intellij mysql set timezone
SQL
2 votes212 views2 answers
Postgresql get table names
SQL
2 votes202 views1 answer
Add new column not null sql server
SQL