/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 vote129 views1 answer
Mysql Digital Ocean connection problems
SQL
1 vote115 views2 answers
Mysql trim whitespace
SQL
0 vote159 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
13 votes129 views3 answers
Uninstall mysql centos 7
SQL
0 vote117 views2 answers
How to get json data mysql
SQL
1 vote121 views1 answer
How to see logical reads in sql server
SQL
0 vote136 views1 answer
Sql server on mac m1
SQL
0 vote127 views1 answer
Mysql cli output to a file
SQL
0 vote110 views1 answer
Postgresql conectar
SQL
0 vote126 views1 answer
Mysql shell ERROR: Not connected.
SQL