/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

2 votes273 views1 answer
Brew start postgres manual
SQL
0 vote287 views1 answer
Count number of entires by months sql
SQL
0 vote264 views1 answer
Mysql workbench primary key
SQL
1 vote327 views1 answer
UseSqlServer no definition
SQL
4 votes298 views2 answers
Float postgres
SQL
0 vote336 views1 answer
Generate a random otp in sql server
SQL
0 vote292 views1 answer
View to table sql
SQL
13 votes309 views3 answers
List all the tables in sql
SQL
13 votes263 views3 answers
Sql online code
SQL
8 votes282 views2 answers
Safe update mode in mysql
SQL