Displaying 2 results from an estimated 2 matches for "phonetagcopy".
2004 Nov 11
2
RODBC & POSIX & Daylight Saving blues
...confusion with a two-line table in an Access 2000 database
table where the single field called '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...
2004 Nov 11
0
ROracle SQL length limitation
...confusion with a two-line table in an Access 2000 database
table where the single field called '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...