/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 vote288 views1 answer
Connexion mysql
SQL
3 votes281 views1 answer
Sql server check version
SQL
6 votes247 views2 answers
Spring data jpa application.properties mysql
SQL
4 votes274 views1 answer
Sql data types
SQL
0 vote286 views1 answer
Hex string sql becomes int64
SQL
0 vote291 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
16 votes330 views1 answer
Sqlserver add column to table
SQL
2 votes280 views1 answer
Check isolation level in mysql
SQL
0 vote284 views1 answer
Declare date variable sql
SQL
0 vote278 views3 answers
Between keyword sql
SQL