/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

16 votes139 views2 answers
Sql exists
SQL
1 vote125 views1 answer
Index a database column sql
SQL
2 votes140 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote144 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
1 vote163 views2 answers
Copy table in sql
SQL
2 votes206 views1 answer
Tsql copy table
SQL
0 vote100 views1 answer
Update set with join pl sql
SQL
-1 vote167 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
4 votes162 views2 answers
SELECT table_name FROM user_tables;
SQL
3 votes136 views4 answers
Order by desc postgres
SQL