/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

1 vote208 views3 answers
Epoch to datetime
SQL
0 vote202 views1 answer
Stuff in sql server
SQL
0 vote220 views1 answer
Sql select random procentage from rows
SQL
1 vote231 views1 answer
Postgresql not in
SQL
0 vote225 views2 answers
Sqlalchemy core in clause
SQL
3 votes226 views1 answer
Oracle list privileges
SQL
1 vote292 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote203 views1 answer
Get duplicate entry sql
SQL
0 vote260 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote209 views1 answer
Format the money fied with comma in international system using sql
SQL