Answers for "mysql convert date time string"

cast string to datetime mysql

SELECT STR_TO_DATE('2017-03-13T14:39:01.123','%Y-%m-%dT%H:%i:%s.%f');

Posted by: Guest on August-07-2020

mysql date to string

-- Convert the current date to YYYYMM format
  SELECT DATE_FORMAT(NOW(), '%Y%m');
  # 201302

Posted by: Guest on July-29-2021

Code answers related to "mysql convert date time string"