Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Read .Net system.datetime
Hello.
Is there any way that I can read a 18-digit .Net system.datetime in Rapidminer? I like to convert it to something readable for a human.
Here is an examble of a number; 634019213109374850
Which should be converted to 2010-02-16T12:48:30.937Z
0
Answers
Hi,
That is actually pretty tough. Originally I thought, that you can just convert the ticks into milliseconds and convert this into a date object (see process below). But the problem is that this does not account for DST, leap seconds etc. which means that in aggregate you are roughly 4 weeks off :smileysad:
I posted the process for educational reasons but this might not something you can easily solve without calling an external .Net routine (which is possible, e.g. with a command line call done by the operator "Execute Program").
Cheers,
Ingo