/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 vote94 views1 answer
Unique vs distinct sql
SQL
4 votes133 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote90 views1 answer
Update set with join pl sql
SQL
1 vote124 views1 answer
Order by oracle
SQL
12 votes199 views4 answers
How to drop all tables in postgresql
SQL
1 vote141 views1 answer
Import mysql dump database command line linux
SQL
7 votes137 views2 answers
Sql server drop temp table if exists
SQL
1 vote130 views2 answers
Replace text in sql
SQL
3 votes120 views2 answers
Mysql create database
SQL
0 vote135 views1 answer
T sql check active deadlock
SQL