How within Visual Query builder, can I export a date column from yyyy-dd-mm to yyyy-MM?
I have tried several things but keep getting an error.
I figured it out. I had to use To_Char
@cowannbell In Alteryx, I would pull the date in with the yyyy-dd-mm format, and use a datetime tool to convert the data. The visual query builder can be funky.
See below screenshot.
Bacon
I need to change the format before pulling the data from the source. I have to do it in Visual Query Builder.