posted 10 years ago
Hi,
I am trying to write data to a csv file. It contains a date string.
In the string buffer (cvsBuffer) it is showing the date string in the correct format that I am expecting (mm/dd/YY). But after writing to csv file it is coming in mm/dd/yyyy format. Is it happening due to utf-8 foramtting? If yes please help me how to avoid this date formatting.
Thanks
Manoj
I am trying to write data to a csv file. It contains a date string.
In the string buffer (cvsBuffer) it is showing the date string in the correct format that I am expecting (mm/dd/YY). But after writing to csv file it is coming in mm/dd/yyyy format. Is it happening due to utf-8 foramtting? If yes please help me how to avoid this date formatting.
Thanks
Manoj
posted 10 years ago
No, I don't think there's any way that UTF-8 would cause that. It seems more likely that there's some other mix-up. Have you looked at the CSV file yourself, or are you relying on some other program which reads the file and parses that field as a Date?
"I'm not back." - Bill Harding, Twister
Manoj Raghuwanshi
Ranch Hand
Posts: 75
Manoj Raghuwanshi
Ranch Hand
Posts: 75
Jim Yingst
Wanderer
Sheriff
Sheriff
Posts: 18671
posted 10 years ago
Frankly, what you describe does not seem to be possible. I think there's likely been some mixup either before or after the getBytes() method call. To figure this out, I recommend putting some print statements as close as possible to the call, before and after:
This should give a better picture of where the problem really lies.
This should give a better picture of where the problem really lies.
"I'm not back." - Bill Harding, Twister
Ulf Dittmer
Rancher
Posts: 42975
76
posted 10 years ago
I just ran the following, and it confirms that all is well in this part of the code (meaning it prints "true").
Where are you seeing the "2007"? Some programs -like Excel- format CSV data upon import, thereby turning 2-digit years into 4-digit years, so that would not be a valid test.
Where are you seeing the "2007"? Some programs -like Excel- format CSV data upon import, thereby turning 2-digit years into 4-digit years, so that would not be a valid test.

No, tomorrow we rule the world! With this tiny ad:
Thread Boost - a very different sort of advertising
https://coderanch.com/t/674455/Thread-Boost-feature
|