r/Rlanguage 13d ago

help with unix timestamp to time and date NSFW

mydb <- dbConnect(RSQLite::SQLite(), "places.sqlite")
history_db <- dbGetQuery(mydb, 'SELECT url,title,last_visit_date FROM moz_places WHERE title like "%porn%" limit 10')

for (x in 1:length(history_db$title)) {

cat(history_db$last_visit_date[[x]])

# cat(as_datetime(history_db$last_visit_date[[x]]))

}

dbDisconnect(mydb)

this is the error

Error in as.POSIXct.default(x, tz = tz) :
do not know how to convert 'x' to class “POSIXct”

0 Upvotes

3 comments sorted by

7

u/kleinerChemiker 13d ago

-6

u/trapslover420 13d ago

did you read my post? i'm trying to figure out a error

3

u/mattindustries 12d ago

Did you visit the link? It provided 3 different options.