How can I write a zuora Query whcih returns me the date in a specific format?

Question

I am trying to write the zuora SQL to return me the EffectiveStartDate of product in 'DD/MM/YYYY' format.

SELECT DATE_FORMAT(EffectiveStartDate, 'DD/MM/YYYY') as formatted_date
FROM product

I am getting the output like this.

formatted_date
    
dd/MM/yyyy  
dd/MM/yyyy  
dd/MM/yyyy  
dd/MM/yyyy  
dd/MM/yyyy  
dd/MM/yyyy

Can someone please tell me what changes do I need to make in the query. Thank you.