The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 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
in Help
Hi,

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


Thanks,

Michel

Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 RM Data Scientist
    Hi,
    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.

    BR,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • 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,

    Michel
Sign In or Register to comment.