Date Time Format

michel7michel7 Member Posts: 26 Maven
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 Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,503 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.