Work with timestamps

PapadPapad Member Posts: 68 image Guru
in Help
Hello everybody,
I have a timestamp in this form: 
Mar 19,2019 7:45:45 AM ETT

In my dataset there are many days. If I want to select only March 19 timestamps, how should I do it?
Thanks in advance.

Tagged:

Best Answer

  • Telcontar120Telcontar120 RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 image Unicorn
    Solution Accepted
    You can also do a Date to Numerical after the first transformation and then provide numbers for the day of the month, month of the year, etc. and do your filters based on that.
    Brian T.
    Lindon Ventures 
    Data Science Consulting from Certified RapidMiner Experts

Answers

  • SGolbertSGolbert RapidMiner Certified Analyst, Member Posts: 344 image Unicorn
    Hi @Papad

    you first have to convert the timestamp column to the Date time type, for example using the Nominal to Date operator. Once it is a Date time, you can use the Filter Examples operator to select the right date.

    It should be easy, note that getting the right format for parsing the date requires some trial and error.

    Regards,
    Sebastian

Sign In or Register to comment.