Options

Work with timestamps

PapadPapad Member Posts: 68 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

  • Options
    Telcontar120Telcontar120 Moderator, RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 1,635 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

  • Options
    SGolbertSGolbert RapidMiner Certified Analyst, Member Posts: 344 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.