How can I keep a date formatted in R using sqldf?

Question

How do I rename a date field in SQLDF without changing the format?

See my example below where my renamed date field "dt" converts the date to a number. How do I avoid this, or convert it back to a date?

#Question for Stack Exchange
df <- data.frame (date = c("2014-12-01","2014-12-02","2014-12-03"),
            acct = c(1,2,3))

df$date = as.Date(df$date)

library("sqldf")
sqldf('
    select 
        date as dt,
        date,
        acct
    from df ')


     dt       date acct
1 16405 2014-12-01    1
2 16406 2014-12-02    2
3 16407 2014-12-03    3

score 12 · Accepted Answer · edited Jul 12 '17 at 07:26

12

Specify the method as follows:

sqldf('select date as dt__Date,
              date as date__Date,
              acct
       from df',
      method = "name__class")

edited Jul 12 '17 at 07:26

zx8754

52,746
12
114
209

answered Dec 30 '14 at 17:50

Keniajin

1,649
2
20
43

How can I keep a date formatted in R using sqldf?

1 Answers1