[R] Problems with time formats when importing data using readHTMLTable
csilva at ipma.pt
Mon Jul 10 17:31:30 CEST 2017
I am extracting positions data from the marine traffic website. The
table has a "Timestamp" column which, in the browser, appears with the
format yyyy-mm-dd HH:MM (UTC), e.g. 2017-07-10 14:04 (UTC).
When I import the table, the same date "2017-07-10 14:04 (UTC)" appears
as "1499696500149969650021 minutes ago", This is the more recent date
and time. Older records, as e.g. "2017-07-09 17:02 (UTC)" appear as e.g.
"1499619726149961972621 hours, 59 minutes ago".
I don't know how to convert these data to the time formats used in R
The script is very simple and worked before:
x <- readHTMLTable('url')
where the 'url' is the link to the website with the specification of the
I appreciate any help.
Divisão de Modelação e Gestão de Recursos Pesqueiros
Av. Dr. Alfredo Magalhães Ramalho
@: csilva at ipma.pt <mailto:csilva at ipma.pt>
#: +351 213027096 <phoneto:+351213027096>
[[alternative HTML version deleted]]
More information about the R-help