/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 vote160 views1 answer
Sql trigger before delete
SQL
12 votes170 views2 answers
Select into insert sql server
SQL
0 vote181 views1 answer
Create dump file mysql workbench
SQL
0 vote160 views1 answer
Soql more than today
SQL
0 vote167 views1 answer
Oracle NLS_CHARACTERSET
SQL
2 votes170 views1 answer
Get hour from date sql
SQL
1 vote179 views1 answer
Sql server: query to find out all the places where the table is used
SQL
1 vote166 views1 answer
Base nosql
SQL
4 votes165 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote169 views1 answer
Search mysql database for column
SQL