/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

4 votes293 views2 answers
Postgresql default value
SQL
0 vote329 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
22 votes290 views4 answers
Show list of users in mysql
SQL
0 vote291 views1 answer
Table values functions in SQL
SQL
0 vote321 views1 answer
Sqlcl format
SQL
4 votes322 views1 answer
Sql delete multiple conditions
SQL
1 vote278 views1 answer
Set mysql mode global query
SQL
0 vote313 views1 answer
Uncheck constraints and delete from table
SQL
1 vote307 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
0 vote319 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL