/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 vote332 views1 answer
T sql less than date
SQL
0 vote357 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote355 views1 answer
In query in sql
SQL
1 vote329 views1 answer
Oracle case
SQL
2 votes342 views1 answer
Sql ends with string
SQL
7 votes322 views2 answers
N highest salary in sql
SQL
0 vote355 views1 answer
Kill mysqld_safe process mariadb
SQL
0 vote360 views2 answers
Temp Space
SQL
1 vote347 views1 answer
Mysql check if string contains comma separated
SQL
0 vote396 views1 answer
Comparing with today and yesterday record in sql query
SQL