/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 vote187 views1 answer
Sql filter rows with condition
SQL
0 vote225 views1 answer
Download sql file of countries names
SQL
0 vote171 views1 answer
Mysql Digital Ocean connection problems
SQL
0 vote155 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote177 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
1 vote161 views1 answer
Postgres get timestamp
SQL
0 vote163 views1 answer
Arithmetic expression in sql
SQL
1 vote182 views1 answer
Continue in sql
SQL
1 vote172 views1 answer
How to drop function in sql
SQL
0 vote175 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL