/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 vote340 views1 answer
Oracle create table auto generated primary key
SQL
-1 vote387 views1 answer
Ms sql select datetime as date
SQL
-1 vote338 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote328 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
5 votes350 views1 answer
Oracle nls parameters
SQL
11 votes391 views5 answers
Laravel db facade
SQL
22 votes343 views3 answers
Sql cheat sheet
SQL
13 votes339 views2 answers
Oracle inner join
SQL
0 vote331 views1 answer
Mysql:5.6 syntax create table
SQL
7 votes324 views2 answers
Create index mysql
SQL