try this: d <- data.frame(ticker=c("IBM", "IBM"), date = as.Date(c("2009-12-03", "2009-12-04")), price=c(120.00, 123.00)) # convert to your desired format d$mydate <- format(d$date, "%m/%d/%Y") write.csv(subset(d, select=-date), file="C:/temp/test.csv", row.names=FALSE)
On Mon, Dec 28, 2009 at 10:19 AM, <george....@bnymellon.com> wrote: > Hi, > > I have a data.frame containing a Date column. When using write.csv() > function to generate a CSV file, I always get the Date column formatted as > "YYYY-MM-DD". I would like to have it formatted as "MM/DD/YYYY", but > could not find an easy way to do it. Here is the test code: > > d <- data.frame(ticker=c("IBM", "IBM"), date = as.Date(c("2009-12-03", > "2009-12-04")), price=c(120.00, 123.00)) > write.csv(d, file="C:/temp/test.csv", row.names=FALSE) > > The test.csv generated looks like this: > > "ticker","date","price" > "IBM",2009-12-03,120 > "IBM",2009-12-04,123 > > I would like to have the date fields in the CSV formatted as "MM/DD/YYYY". > Is there any easy way to do this? > > Thanks in advance. > > George Zou > > The information contained in this e-mail, and any attachment, is > confidential and is intended solely for the use of the intended recipient. > Access, copying or re-use of the e-mail or any attachment, or any > information contained therein, by any other person is not authorized. If you > are not the intended recipient please return the e-mail to the sender and > delete it from your computer. Although we attempt to sweep e-mail and > attachments for viruses, we do not guarantee that either are virus-free and > accept no liability for any damage sustained as a result of viruses. > > Please refer to http://disclaimer.bnymellon.com/eu.htm for certain > disclosures relating to European legal entities. > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html<http://www.r-project.org/posting-guide.html> > and provide commented, minimal, self-contained, reproducible code. > -- Jim Holtman Cincinnati, OH +1 513 646 9390 What is the problem that you are trying to solve? [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.