[R] How to change the default Date format for write.csv function?

[Henrique Dallazuanna]

Use the quote argument:

write.csv(d, file="C:/temp/test.csv", row.names=FALSE, quote = FALSE)

On Mon, Dec 28, 2009 at 2:17 PM,  <George.Zou at bnymellon.com> wrote:
> Hi,
>
> This problem might be a little harder than it appears.
>
> I receive a few emails all suggesting that convert the Date field to
> character by calling format(date, "%m/%d/%Y") in one way or another. Well,
> this is not the solution I'm looking for and it doesn't work for me.   All
> the date fields are generated with quotes around them, which will be
> treated by other software as string instead of date.   Please note, the
> write.csv() function doesn't put quotes around date.   All I need is to
> change the format behavior of Date without adding any quotes.  So the
> output of CSV I'm looking for should be:
>
> "ticker","date","price"
> "IBM",12/03/2009,120
> "IBM",12/04/2009,123
>
> Not this:
>
> "ticker","date","price"
> "IBM","12/03/2009",120
> "IBM","12/04/2009",123
>
> Thanks for trying though.
>
> George
>
>
>
> From:
> George.Zou at bnymellon.com
> To:
> r-help at r-project.org
> Date:
> 12/28/2009 10:20 AM
> Subject:
> [R] How to change the default Date format for write.csv function?
> Sent by:
> r-help-bounces at r-project.org
>
>
>
> 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 at 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.
>
>
>
>
> 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 at 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.
>



-- 
Henrique Dallazuanna
Curitiba-Paraná-Brasil
25° 25' 40" S 49° 16' 22" O