Answers for "giving the value for date in mysql table"

SQL
0

where date in datetime mysql

WHERE DATE(datetime) = '2009-10-20'
like this
WHERE datetime LIKE '2009-10-20%'
Posted by: Guest on September-03-2021
0

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'  ;
Posted by: Guest on August-20-2021

Code answers related to "giving the value for date in mysql table"

Code answers related to "SQL"

Browse Popular Code Answers by Language