Sample Header Ad - 728x90

How to change the timestamp format of percona mysql audit logs

0 votes
1 answer
39 views
I have a RHEL linux server where I have installed mysql percona and set the auditing. The Queries received in the audit record has timestamp in below format. {"audit_record":{"name":"Query","record":"179295580_2024-10-03T10:56:38","timestamp":"2024-10-03T10:57:54 UTC","command_class":"drop_table","connection_id":"2","status":0,"sqltext":"drop table DPT","user":"abc[abc] @ localhost []","host":"localhost","os_user":"","ip":"","db":""}} In the above record , timestamp has UTC. ""timestamp":"2024-10-03T10:57:54 UTC"," And I want it in this format: "timestamp":"2024-10-03T10:57:54Z". Basically I want to replace UTC with Z. I tried changing the timezone of the server , but its no help. Please help me with this. Thankyou
Asked by Raja (1 rep)
Oct 3, 2024, 12:33 PM
Last activity: Oct 4, 2024, 12:57 PM