Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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

Labels (1)
1 Reply
its_anandrjs
Champion III
Champion III

Dear

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

Regards

Anand