DATE_FORMAT SQL Issue

Hi There,

 

I'm tyring to convert my date field from a 12 hour time stamp, to a 24 hour timestamp. I tried using DATE_FORMAT(`Date Field`, '%Y-%m-%d %H:%m:%s') but it gives me a completely different date AND time than what the actual value is. 


Has anyone ever encountred a similar issue and have any advice. Thanks!

Comments