i load on local computer (Mac) with RPostgreSQL file from PostgreSQL and i have time instead of "2015-02-03 12:12:12" "2015-02-03"
. i need true time, please help.
library(RPostgreSQL)
command <- "SELECT * FROM xxx;"
xxx <- dbSendQuery(con, xxx)
OR
xxx <- dbReadTable(con, "xxx")
class(xxx$time)
[1] "POSIXct" "POSIXt"