/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 vote219 views3 answers
Remove folders from remote git
SQL
0 vote230 views1 answer
Database db connection string format
SQL
1 vote209 views1 answer
Show all event schedular on mysql
SQL
1 vote321 views1 answer
SQL server query column yes or no
SQL
0 vote207 views1 answer
Sql count * vs count 1
SQL
0 vote200 views1 answer
Mysql count grouped rows
SQL
3 votes214 views2 answers
Sqlite print all column names
SQL
0 vote267 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote269 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
0 vote183 views1 answer
Mariadb set vertical output format
SQL