search for: swissrisk

Dear all, I have found the following (for me) incomprehensible behaviour of ISOdate (POSIXct): > ISOdate(1900,6,16) [1] "1900-06-15 14:00:00 Westeurop?ische Sommerzeit" > ISOdate(1950,6,16) [1] "1950-06-16 14:00:00 Westeurop?ische Sommerzeit" Note that in the first case I get the 15th of June back, not the 16th as I would have expected! This happened under R-1.7.1 on

Hi All, I’m using system commands in R to send requests to my database. CMD=paste(“isql.tcl \’ select xxxx from yyyyy where zzzzz = 501 \’”) Data=system(CMD,intern=T) This works perfectly fine, but if I want to be able to add dates constraints: In command line it would be isql.tcl “ select xxxx from yyyyy where zzzzz = 501 and date>’20021020’ ” Does somebody has an idea how to