In a bash script, we have the following which is being used for time stamps;
TIME="$(date +"%F %T")"
The above is being stored in the following mysql field;
Field name Type Allow nulls? Key Default value Extras
id int(11) No Primary NULL auto_increment
time timestamp No None CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
First, what do I need to change in the script to in order to start sending 24hr clock format instead?
Second, is there any way of converting the data already stored in the database from 12hr format to 24hr format?
If you reply, please understand that I am not a database person so will need actual instructions or a script or what ever the solution might be.