Loaded time is without hours, minutes and seconds

98 views Asked by At

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" 
0

There are 0 answers