Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

date fonctions

Hello Guys,

Hope all is all

Could anyone explain to me the fonctions to_date/ to_char/to_months ?? and why they are used together in the expression bellow

date>= to_date(to_char(add_months(SYSDATE,-6),'DD/MM/YYYY'),'DD/MM/YYYY')

Thank you so much

1 Reply
its_anandrjs

Dear

It is a SQL related question better you can discussed this on SQL community.

Regards

Anand