/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 vote292 views1 answer
Oracle see column type
SQL
0 vote248 views1 answer
Postgresql create table default value timestamp
SQL
5 votes255 views1 answer
Mysql get last day of month
SQL
1 vote269 views1 answer
How to change owner in postgres
SQL
0 vote280 views1 answer
Mysql where in maintain order
SQL
9 votes251 views6 answers
Sql insert into
SQL
1 vote263 views1 answer
Moodle query first user access
SQL
42 votes358 views6 answers
Rename table sql server
SQL
0 vote261 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
0 vote277 views1 answer
Psql list rules
SQL