Date Format is changed in CSV File

[Amit4]

Hi,

This is my Job in which I am storing date in a CSV File. But in CSV file date is getting stored in only dd-MM-YYYY format even if it different in my JAVA component. It is printing the mentioned format in log row but in file it is storing only in dd-MM-YYYY format.

This is the output in the Log row table which is in specified format YYYY-MM-dd HH:mm:ss

But here you can see that in my CSV File it is getting stored in the dd-MM-yyyy format only.

Please look into it.

Thanks and regards

Amit

[zjing · Accepted solution]

hello,

You should open your file CSV in Notpad++ or bloc_notev as a file txt.You will can see the good format.

if you open it directely in CSV, the configuration by default in CSV will be used.

best wishes