/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 votes234 views1 answer
Connect mysql docker
SQL
1 vote241 views1 answer
Rename table column name in mysql
SQL
0 vote196 views1 answer
Mysql find foreign key references
SQL
2 votes240 views1 answer
Sql as
SQL
6 votes221 views1 answer
Oracle rank() over (partition)
SQL
5 votes249 views1 answer
How to get all dates in a month in oracle
SQL
0 vote225 views1 answer
How to insert same table data using mysql query
SQL
3 votes233 views1 answer
Oracle rollback
SQL
-1 vote226 views1 answer
How to open blade file from blade in laravel
SQL
1 vote237 views3 answers
Connection string mysql
SQL