/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 vote145 views1 answer
T-sql conditional order by multiple columns
SQL
0 vote147 views1 answer
Ajax error exception handeling
SQL
0 vote307 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
2 votes134 views1 answer
SQL IF ELSE
SQL
0 vote109 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote138 views1 answer
C# datetime to sql server datetime
SQL
0 vote137 views1 answer
Sql insert tuple
SQL
11 votes144 views1 answer
Sql query to find duplicates in column
SQL
3 votes192 views2 answers
Oracle sql first day of month
SQL
0 vote145 views1 answer
Alter table engine mysql
SQL