Work with timestamps

Papad
Papad New Altair Community Member
edited November 5 in Community Q&A
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

  • Telcontar120
    Telcontar120 New Altair Community Member
    Answer ✓
    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.

Answers

  • SGolbert
    SGolbert New Altair Community Member
    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

  • Telcontar120
    Telcontar120 New Altair Community Member
    Answer ✓
    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.

Categories