/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

3 votes274 views2 answers
Df to sql pandas sql achemy
SQL
6 votes306 views2 answers
Foreign key sqlite3 python
SQL
1 vote250 views1 answer
Can we drop a primary key
SQL
0 vote260 views1 answer
List MySQL Table and Index Size
SQL
10 votes269 views1 answer
Create table oracle
SQL
0 vote266 views1 answer
Get first monday of month sql
SQL
6 votes321 views2 answers
Install psql mac
SQL
0 vote286 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote309 views1 answer
Stored procedure function relation
SQL
0 vote292 views2 answers
How to prevent sql injection in java
SQL