MYSQL – promjena samo vremena na datetime polju

Problem:

želimo datetime polju promijeniti samo vrijeme, a da nam datum ostane isti

 

Rješenje: 

UPDATE tbl_tablica SET datum = CONCAT(date(datum)," ", CURTIME())

WHERE id=123

ovo unesenom datumu pridodaje trenutno vrijeme

This entry was posted on Tuesday, July 7th, 2015 at 11:09 amand is filed under MYSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.