convert date format while using date_add function in mysql

Question

I'm using the query below to add 14 days to a date

SELECT DATE_ADD(Paper_Sent_Dt,INTERVAL 14 DAY) as Rem_date from Referee_History;

the date format is yyyy/mm/dd but I require it in dd/mm/yyyy format. Is it possible to convert the date format while using the DATE_ADD function??

as in, something like this

SELECT CONVERT(DATE_ADD(Paper_Sent_Dt,INTERVAL 14 DAY),%d-%m-%y) as Rem_date from Referee_History

if yes, please tell me how Thanks in advance

Punitha Subramani · Accepted Answer · 2014-09-04 09:45:39Z

2

Something like this, Can you try it?

SELECT DATE_FORMAT(DATE_ADD('2014-06-06',INTERVAL 14 DAY), '%d/%m/%Y');

O/P

20/06/2014

answered Sep 4, 2014 at 9:45

Punitha Subramani

1,4621 gold badge8 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kamran Ahmed · Accepted Answer · 2014-09-04 09:44:36Z

0

Your query would be something lik:

SELECT 
    DATE_FORMAT(DATE_ADD(Paper_Sent_Dt,INTERVAL 14 DAY),%d-%m-%y) as Rem_date  
FROM 
    Referee_History

answered Sep 4, 2014 at 9:44

Kamran Ahmed

12.5k24 gold badges73 silver badges103 bronze badges