迄今为止的秒数转换 [英] Number of seconds to date conversion
问题描述
我有一个数据集,其中一列是销售日期。不知道为什么,但是R会将其转换为数字,为什么执行任何操作。我想将其转换回R中的 POSIXct
日期格式。为此,我使用下面的代码,但得到了意外的结果
I have a data set where one of the columns is sales date. Don't know why, but R converts it to numeric why performing any operation. I would like to convert it back to POSIXct
date format in R. To do the same, I am using below code, but getting an unexpected result
x= as.Date(1448208000, origin = "1970-01-01")
[1] "3967028-10-31"
x= as.POSIXct(x,"%Y-%m-%d")
我对R中的日期格式不太满意,在这方面会提供任何帮助。
I am not good with dates format in R and would appreciate any kind of help in this regard.
推荐答案
1448208000
是自unix时代以来的秒数,并且是POSIX对象的数字表示形式。要将其转换回 POSIXct
1448208000
is the number of seconds since the unix epoch, and is the numeric representation of a POSIX object. To convert it back to POSIXct
you want
as.POSIXct(1448208000, origin = "1970-01-01")
您可能还想确保时区正确;看到这两个命令之间的区别
You'll also probably want to ensure the timezone is correct too; see the difference between these two commands
as.POSIXct(1448208000, origin = "1970-01-01", tz = "UTC")
# [1] "2015-11-22 16:00:00 UTC"
as.POSIXct(1448208000, origin = "1970-01-01", tz = "Australia/Melbourne")
# [1] "2015-11-23 03:00:00 AEDT"
这篇关于迄今为止的秒数转换的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!