Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Work with timestamps

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.

Find more posts tagged with

AI Studio

ETL + Data Prep

Accepted answers

Telcontar120

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.

All comments

SGolbert

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

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.