How to format database column before export to csv

What I need to achieve:

I want to format my database output for example date format, replace, titlecase etc. before exporting them to csv. I need the output of the csv to be end user readable friendly.