Register and ask your own question!
mysqldump or export to csv in a different timestamp format
I have a Percona Xtradb cluster 5.7 with many tables with timestamp column/columns. I need to export the data of all the tables into a csv or mysqldump file . The problem i am facing is that the output file needs to be in a different timestamp format as below
2020-01-22 19:24:27.953 (current)-----------------> 22-JAN-2020 7:24:27.953 PM ( desired)
Is there any way i can set any variable at session level to take a dump of the data ?
The problem with using DATE_FORMAT is that, i need to set it for each timestamp column of the table . Also I will need to define the columns explicitly instead of using 'SELECT *'