Monday, June 2, 2014

MySQL - Update only Time of a 'DateTime' column

UPDATE `table` SET `date_column` = CONCAT(DATE(`date_column`), ' 23:59:59') 

No comments:

Post a Comment