The CREATED and LAST_ALTERED columns are defaulted to ‘0000-00-00 00:00:00’ and does not get changed post altering or creating a function. I’m using 7.1.4 version . Is there any log variable i need to turn ON?

We’re tracking this as a feature request. Currently it is expected that they are not filled in. The output schema is for compatibility with MySQL clients, even though the information isn’t populated at this point.