Every time I run the queries, the date is taken as "dd-MM-yyyy". I wanted to change this default pattern to "MM/dd/yyyy" which is required for all my jobs. I have read some other posts where discussion on this topic is done, however I could not find the solution. Can anyone help me out?
you are not a first, not a 2nd ... and even not a 3rd who ask for this
from the oldest request (registered in JIRA) - just 9 years passed, be calm! 1 :-) more and will be jubilee!
This may probably work out
map the input field to a tMap and change the date pattern to anything you want like I have done.
Refer to the attachment
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Accelerate your data lake projects with an agile approach