[R-sig-DB] how to?

[XFM]

Another question:

I have:

> T[1,1]
[1] "2009-04-27 MYT"

but

>as.Date(T[1,1])
[1] "2009-04-26"

and
> typeof(as.Date(T[1,1]))
[1] "double"

There is no "date" type? and why has the date changed?

Thank you
xavier

On Mon, Apr 27, 2009 at 6:50 PM, XFM <XFM using xx> wrote:
> Hi again,
>
> I have now a data.frame object obtained with an ODBC sqlQuery.
> I have basically two columns. One is the dates of observation, the
> second is the value of the observation.
> My problem is that the typeof of the elements of the first column is
> 'double' whereas it should be a date. I try to use the as.if option in
> sqlQuery to convert directly the first column into date, can somebody
> help me with an example?
>
> Thank you very much
>
> Xavier
>
>
> On Thu, Apr 23, 2009 at 12:18 PM, <XFM using xx> wrote:
>>
>> Thank you very much, with your help and the help files, I have been
>> able to do sql queries to a SQLserver through ODBC.
>> Xavier
>>
>> On Wed, Apr 22, 2009 at 11:59 PM, Jim Burke <j.burke using earthlink.net> wrote:
>> >
>> > Below is what I use to connect to MySQL. Along
>> > with a moderate query.  Perhaps Xavier might adapt
>> > this for his use with SQLServer.
>> >
>> > I am relatively new to R and find most of this to
>> > be quite easy to do. Especially after reading the
>> > help files in R.
>> >
>> > And I use PremiumSoft's Navicat to provide a nice
>> > GUI interface to MySQL.
>> >
>> > Notice a couple of things in the code below.
>> > `Candidate Name` wants a kind of quote like
>> > below the tilde on the left side of my
>> > keyboard. This is necessary if there are
>> > spaces in your table's column name. Might
>> > be MySQL specific.
>> >
>> > library(RMySQL)
>> > mycon <- dbConnect(MySQL(), user='root', dbname="mysql", password='pass')
>> >
>> > rs <- dbSendQuery(mycon,
>> >   "SELECT
>> >       SUBSTR(`Precinct-Ballot Style`,1,4) AS 'PCT',
>> >       SUM(`Total Count/Registered Voter`) AS 'D_TOT',       `Candidate Name` AS D_CANDIDATE_NAME
>> >    FROM precinct
>> >    WHERE
>> >        `Contest Title` LIKE '%108'
>> >     GROUP BY SUBSTR(`Precinct-Ballot Style`,1,4);"
>> >     )
>> > data_dem <- fetch(rs, n = -1)
>> > dbClearResult(rs)
>> >
>> > Good luck,
>> > Jim Burke
>> >
>> >
>> > Prof Brian Ripley wrote:
>> >>
>> >> On Wed, 22 Apr 2009,  wrote:
>> >>
>> >>> Hello,
>> >>>
>> >>> I use windows XP, I have RGui with R version 2.8.1
>> >>> I try to connect to a microsoft SQL database with is on a remote shared disk.
>> >>> I have downloaded RODBC and DBI that I would like to use after if its simple.
>> >>>
>> >>> For the moment I just try to connect with the DB, using
>> >>>
>> >>> odbcConnect(dsn, uid = "", pwd = "", ...)
>> >>> Actually I donnot understand what is dsn. The doc says
>> >>>
>> >>> character string. A registered data source name.
>> >>>
>> >>> But seriously it is not enough...
>> >>
>> >> If you are using ODBC, it is.  Did you read the README in the package?
>> >> And you ODBC documentation?
>> >>
>> >>> Whats that? The path to the DB?
>> >>> I need a more detailed example than the one which is in the doc.
>> >>
>> >> Like the ones in the installed tests.R file?
>> >>
>> >>> Thank you
>> >>>
>> >>> xavier
>> >>>
>> >>> On Fri, Apr 17, 2009 at 5:03 PM, Prof Brian Ripley
>> >>> <ripley using stats.ox.ac.uk> wrote:
>> >>>>
>> >>>> On Fri, 17 Apr 2009, wrote:
>> >>>>
>> >>>>> Hello,
>> >>>>>
>> >>>>> I have downloaded R and I would like to do some sql queries. But I have
>> >>>>> difficulties to find information. Do I need to download an additional
>> >>>>
>> >>>> Have you read the 'R Data Import/Export Manual' that is installed with R?  That covers this.
>> >>>>
>> >>>>> package? And then, what is the procedure?
>> >>>>
>> >>>> All the information requested in the R posting guide is missing.  We have no idea what platform you are using, what DBMS you are intending to use ....
>> >>>>
>> >>>> See http://www.r-project.org/posting-guide.html
>> >>>>
>> >>>>> Thank you very much for your help.
>> >>>>>
>> >>>>> Xavier
>> >>>>>
>> >>>>>       [[alternative HTML version deleted]]
>> >>>>
>> >>>> Please also note that the R posting guide asked you not to send HTML mail.
>> >>>>
>> >>>>> _______________________________________________
>> >>>>> R-sig-DB mailing list -- R Special Interest Group
>> >>>>> R-sig-DB using stat.math.ethz.ch
>> >>>>> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>> >>>>>
>> >>>>
>> >>>> --
>> >>>> Brian D. Ripley,                  ripley using stats.ox.ac.uk
>> >>>> Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
>> >>>> University of Oxford,             Tel:  +44 1865 272861 (self)
>> >>>> 1 South Parks Road,                     +44 1865 272866 (PA)
>> >>>> Oxford OX1 3TG, UK                Fax:  +44 1865 272595
>> >>>
>> >>> _______________________________________________
>> >>> R-sig-DB mailing list -- R Special Interest Group
>> >>> R-sig-DB using stat.math.ethz.ch
>> >>> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>> >>>
>> >>
>> >> ------------------------------------------------------------------------
>> >>
>> >> _______________________________________________
>> >> R-sig-DB mailing list -- R Special Interest Group
>> >> R-sig-DB using stat.math.ethz.ch
>> >> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>> >>
>> >
>