/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 vote196 views1 answer
On delete set default
SQL
1 vote220 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote180 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote167 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote232 views1 answer
Updating database in sql
SQL
7 votes185 views3 answers
Python and mysql connectivity
SQL
3 votes217 views2 answers
Search text in all sql server stored procedure
SQL
0 vote175 views2 answers
How to combine diff colmun value using group by postgres
SQL
2 votes200 views1 answer
Removing view
SQL
4 votes168 views1 answer
Sql group by year
SQL