Different output when using date_format in pyspark script node

While standardizing date , I had used date format to convert string to date type when I validated on 10 rows inside the pyspark script the format of date was YYYY-MM-DD but when I executed my output was in different format that was in dd-MMM-YYYY. I just wanted to know what is the default format .

I have shared the screenshot of the output in pyspark and excel

Hello @ruks,

What you are seeing are different tools rendering the datetime cells in different ways. This has no effect to the underlying data. All of these tools should have specific datetime functions that will pull the information requested from the data.

Also, within the KNIME table view, if you right click on the datetime column, you have multiple options for how to render.

-Stephen

2 Likes