MySQL: insert current date plus specific time

Question

How do I insert a field with current date and specific time?
My goal is to insert CURDATE() with a specific hour 17:30:00.

I tried like
INSERT INTO table VALUES('', CURDATE(+ ' 17:30:00'))
but it doesn't work.

Answer 1

Try this -

  CONCAT(CURDATE(), ' 17:30:00')