[R-sig-DB] Date time, MSSQL and RODBC

[Daniele Amberti]

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]]