/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 vote199 views1 answer
Get week day name sql server
SQL
0 vote216 views1 answer
How to get data from 2 database
SQL
2 votes197 views1 answer
Sql count having
SQL
3 votes240 views1 answer
Sql double index
SQL
0 vote202 views1 answer
Access mysql database docker container shell
SQL
3 votes186 views3 answers
Stop mysql service ubuntu
SQL
12 votes196 views1 answer
How to change the value of a table in sql
SQL
2 votes196 views2 answers
Sql query to copy data from one column to another
SQL
0 vote203 views1 answer
Sql query to select records entered in last 24 hours
SQL
6 votes215 views2 answers
Mysql concatenate two columns into one
SQL