/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 vote202 views1 answer
Mysql url
SQL
6 votes183 views2 answers
Mysql version check cmd
SQL
0 vote167 views2 answers
Sql select inside select
SQL
1 vote183 views3 answers
What is union in sql
SQL
2 votes173 views1 answer
Docker run postgres locally
SQL
0 vote157 views1 answer
Opensuse status MySQL
SQL
1 vote194 views3 answers
Mysql on delete set null
SQL
0 vote195 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
4 votes185 views2 answers
Sql offset
SQL
0 vote184 views1 answer
Sql server bool select
SQL