The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.

Date Time Format

michel7michel7 Member Posts: 26 Maven

I imported datetime values from MS SQL database, e.g.  2021-11-10 08:23:00.000.

What to do  for keeping the format  ? No AM / PM, no CEST / EST... 




  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,525 RM Data Scientist
    Date-time columns are always Unix time stamps. No matter what we display, its always converted to ms since 1970. What you see with AM, M CEST and so on is just the visualization.

    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    michel7michel7 Member Posts: 26 Maven
    edited December 2022
    Hi Martin,

    thanks a lot. The questions in that case:

    how to 
    1. change the visualization ? 
    2. import unix time as time, not a string ?

    Warm regards,

Sign In or Register to comment.