/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 vote117 views1 answer
Get the First and Last Word from a String or Sentence
SQL
3 votes116 views3 answers
Start postgresql ubuntu
SQL
17 votes115 views3 answers
Postgresql version command
SQL
3 votes112 views1 answer
Sql double index
SQL
0 vote119 views1 answer
Get schema of table sql
SQL
8 votes117 views1 answer
How to check mysql version in xampp
SQL
5 votes193 views2 answers
Mysql date greater than 30 days
SQL
7 votes120 views5 answers
Max 3 salary in sql
SQL
0 vote182 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
3 votes110 views2 answers
Sql add year to date
SQL