[R] problem with unlist POSIX date at midnight
Hanneke Schuurmans
H.Schuurmans at geo.uu.nl
Wed Jan 17 13:50:35 CET 2007
Dear R-users,
I use unlist of POSIX dates to extract the year, hour etc. With that I
can search for files in my database which are in the form
'yyyymmddhh_synops.txt'
However, I get stucked during midnight where unlist just gives NA's.
The script is given below; the problem accurs at acc.period[16]
(midnight). However when I write out the character, unlist works well.
But as.character(acc.period[16]) is not the solution....
> dates=seq(as.Date("2006-03-01"), as.Date("2006-11-01"), "days")
> i=1
> begin=paste(dates[i]-1,"09:00:00")
> end=paste(dates[i],"08:00:00")
> acc.period=seq(as.POSIXct(begin),as.POSIXct(end),"hour")
>
> unlist(strptime(acc.period[15],format="%Y-%m-%d %H:%M:%S"))
sec min hour mday mon year wday yday isdst
0 0 23 28 1 106 2 58 0
> unlist(strptime(acc.period[16],format="%Y-%m-%d %H:%M:%S"))
sec min hour mday mon year wday yday isdst
NA NA NA NA NA NA NA NA -1
> unclass(strptime(acc.period[16],format="%Y-%m-%d %H:%M:%S"))
$sec
[1] NA
$min
[1] NA
$hour
[1] NA
$mday
[1] NA
$mon
[1] NA
$year
[1] NA
$wday
[1] NA
$yday
[1] NA
$isdst
[1] -1
>
> a="2006-03-01 00:00:00"
> unlist(strptime(a,format="%Y-%m-%d %H:%M:%S"))
sec min hour mday mon year wday yday isdst
0 0 0 1 2 106 3 59 0
>
> sessionInfo()
R version 2.4.0 (2006-10-03)
i386-pc-mingw32
locale:
LC_COLLATE=English_United States.1252;LC_CTYPE=English_United
States.1252;LC_MONETARY=English_United
States.1252;LC_NUMERIC=C;LC_TIME=English_United States.1252
attached base packages:
[1] "methods" "stats" "graphics" "grDevices" "utils" "datasets"
[7] "base"
Thanks in advance!
Hanneke
--
---------------------------------------------
ir J.M. (Hanneke) Schuurmans
PhD student Hydrology
Department of Physical Geography
Faculty of Geosciences - Universiteit Utrecht
P.O. Box 80115 3508 TC Utrecht
T +31 (0)30 2532988 F +31 (0)30 2531145
W www.geo.uu.nl/staff/schuurmans
More information about the R-help
mailing list