Dates/Times retrieved from DB gets convert to time zone in settings- How can I prevent this
I just realized that the dates retrieved from a database using the 'Read Database' operator gets converted to what ever the time zone setting is in the preferences. I do not want this to happen. I want RM to use return the date/time exactly as it is in the database. How can I do this?
Sharan_Gadi Administrator, Moderator, Employee, Member Posts: 6 RM Team Member@ecdbert - Have you tried modifying the database connection to not to use TimeZone parameter as shown below in screenshot and see if that helps ?2
For example, if I change my RapidMiner Studio settings to America/New_York the current date and time (date_now()) is displayed as: Feb 25, 2021 4:57:14 AM EST. Writing the date to an Excel file using Write Excel results in a file that shows the date value as 2021-02-25 10:57:14 when opened in Excel. This matches my Windows settings that use central European time. Please note, that both representations refer to the same point in time.
In other words, as long as the values shown in RapidMiner Studio refer to the same point in time as the values in the database, no conversion was applied.
Second, the target database might insist on storing a timezone alongside the "point in time". In that case RapidMiner might default to the current settings.
Either way, details will depend on the database systems in use. I will put you in contact with our support.
I’ll await a response from support.