Answers for "how to set date in mysql"

SQL
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
-1

date in mysql

YYYY-MM-DD

--April 21 2021 would be
'2021-04-21'

--June 5 1944 would be
'1944-06-05'
Posted by: Guest on January-12-2022

Code answers related to "how to set date in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language