Displaying 4 results from an estimated 4 matches for "datetest".
Did you mean:
natetest
2006 Jul 11
4
Date Format
...equest, but I do not manage to solve this.
When I use a "table" function with dates in the rows, the rows are coerced to number after the table function.
So I need to transform the row names into date format. But I do not manage.
Therefore, for an example, I manage to write this :
datetest<-"06/01/2001"
datetest<-as.Date(datetest,"%d/%m/%Y")
datetest<-as.numeric(datetest)
to get 11328.
But I do not obtain the inverse tranformation :
datetest<-as.Date(datetest,"%d/%m/%Y")
How do we get this please ?
Thanks a lot for your solution.
Pi...
2006 Jul 11
4
Date Format
...equest, but I do not manage to solve this.
When I use a "table" function with dates in the rows, the rows are coerced to number after the table function.
So I need to transform the row names into date format. But I do not manage.
Therefore, for an example, I manage to write this :
datetest<-"06/01/2001"
datetest<-as.Date(datetest,"%d/%m/%Y")
datetest<-as.numeric(datetest)
to get 11328.
But I do not obtain the inverse tranformation :
datetest<-as.Date(datetest,"%d/%m/%Y")
How do we get this please ?
Thanks a lot for your solution.
Pi...
2004 Nov 11
2
RODBC & POSIX & Daylight Saving blues
...alled 'theDate' contains the two values:
30/07/04 12:00:00
30/11/04 12:00:00
then I bring the datetimes into R with the following code:
> library (RODBC)
> theChannel <- odbcConnect("phonetagcopy", "", "")
> pp <- sqlFetch(theChannel, "DateTest")
> odbcClose(theChannel)
> pp$theDate
[1] "2004-07-30 12:00:00 GMT Daylight Time"
[2] "2004-11-30 12:00:00 GMT Standard Time"
>
> unclass(pp$theDate) / 86400
[1] 12629.46 12752.50
attr(,"tzone")
[1] ""
>
> difftime (pp$theDate[1]...
2004 Nov 11
0
ROracle SQL length limitation
...alled 'theDate' contains the two values:
30/07/04 12:00:00
30/11/04 12:00:00
then I bring the datetimes into R with the following code:
> library (RODBC)
> theChannel <- odbcConnect("phonetagcopy", "", "")
> pp <- sqlFetch(theChannel, "DateTest")
> odbcClose(theChannel)
> pp$theDate
[1] "2004-07-30 12:00:00 GMT Daylight Time"
[2] "2004-11-30 12:00:00 GMT Standard Time"
>
> unclass(pp$theDate) / 86400
[1] 12629.46 12752.50
attr(,"tzone")
[1] ""
>
> difftime (pp$theDate[1]...