/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

1 vote333 views1 answer
Convert varchar to int in sqlite
SQL
5 votes346 views1 answer
AND OR NOT operators sql
SQL
1 vote354 views1 answer
Where not in array sql
SQL
0 vote376 views1 answer
New rails app with mysql
SQL
0 vote355 views1 answer
List in one column mysql
SQL
0 vote348 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
1 vote376 views3 answers
How to reset id column in sql server
SQL
3 votes316 views4 answers
Show columns from table
SQL
0 vote347 views1 answer
If column value is null then in mysql
SQL
0 vote332 views1 answer
How to user id to show in from date to upto date in mssql server
SQL