I am having an issue with the DATETIME function in mysql. When I store a record in the table, I am trying to use DATETIME to record the date and time is was entered but whenever a record is entered, the correct date is displayed but the time is always 0. Meaning to say that it always displays as: 2021-01-06 00:00:00.
I have looked around online but cannot see anywhere to help me solve this.
I have tried both DATETIME and TIMESTAMP with both the default set to NONE and CURRENT_TIME, but none of those combinations are storing the time.