/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

8 votes185 views2 answers
Phpmyadmin default password
SQL
18 votes178 views3 answers
Mysql add column with default value
SQL
0 vote184 views1 answer
Psql list view rules
SQL
0 vote195 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote220 views1 answer
Use mysql in java program
SQL
1 vote182 views1 answer
Get last week data in mysql
SQL
3 votes188 views1 answer
Get all elements sql
SQL
23 votes200 views6 answers
Create table sql server
SQL
0 vote204 views1 answer
USING THE NOT CONDITION IN SQL
SQL
-1 vote185 views1 answer
Round up and down sql
SQL