/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

7 votes160 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
2 votes208 views1 answer
Mysql create user with remote access
SQL
0 vote191 views1 answer
Sql int vs integer
SQL
0 vote133 views1 answer
Java sql connection
SQL
0 vote134 views1 answer
Ignore case in string sql
SQL
15 votes121 views4 answers
T-sql drop function if exists
SQL
5 votes130 views1 answer
Invalid column name sql
SQL
1 vote94 views1 answer
Ms sql how to see active job current run time
SQL
0 vote128 views1 answer
Mysql find missing values
SQL
0 vote101 views1 answer
Mysql insert with foreign key
SQL