/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 vote202 views1 answer
To_date sql
SQL
0 vote217 views1 answer
Varchar format not case sensitive sql
SQL
5 votes182 views1 answer
Postgres integer to serial
SQL
0 vote223 views2 answers
While mysql
SQL
5 votes172 views2 answers
Oracle list columns schema
SQL
1 vote325 views1 answer
Sql injection
SQL
4 votes187 views1 answer
Mysql timestamp in laravel migration
SQL
0 vote200 views1 answer
Get record which is available in one table but not in another mysql
SQL
9 votes190 views3 answers
Mysql show table column full description
SQL
0 vote189 views1 answer
Sql case when exists in another table
SQL