Hi,
I have to connect to MSSQL server to get some TimeSeries value (datetime,
float) on output.
Datetime data type in R is a POSIXct date with information about timezone,
daylight or solar time.
In the DB I have not this kind of information and this cause some problem at
the change of time for energy savings.
Any idea on how to connect and have an simple and clear interpretation of date
(without all this information)?
Which is the best way to connect to MSSQL server with R on windows?
When I insert datetime into the DB with R there are problems in the date
interpretation (I think this depend on the system settings of R installation
(on windows) and MSSQL installation. Sometimes it works directly (POSIXct to
DB) sometimes I have to format a POSIXct to YYYYmmdd format to be able to
insert date. What about a safe methodology about this kind of operation?
Thanks in advance
Daniele
________________________________
ORS Srl
Via Agostino Morando 1/3 12060 Roddi (Cn) - Italy
Tel. +39 0173 620211
Fax. +39 0173 620299 / +39 0173 433111
Web Site www.ors.it
------------------------------------------------------------------------------------------------------------------------
Qualsiasi utilizzo non autorizzato del presente messaggio e dei suoi allegati
è vietato e potrebbe costituire reato.
Se lei avesse ricevuto erroneamente questo messaggio, Le saremmo grati se
provvedesse alla distruzione dello stesso
e degli eventuali allegati.
Opinioni, conclusioni o altre informazioni riportate nella e-mail, che non
siano relative alle attività e/o
alla missione aziendale di O.R.S. Srl si intendono non attribuibili alla
società stessa, né la impegnano in alcun modo.
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
