image

🎉 🎉 RAPIDMINER 9.10 IS OUT!!! 🎉🎉

Download the latest version helping analytics teams accelerate time-to-value for streaming and IIOT use cases.

CLICK HERE TO DOWNLOAD

Convert polynomial to date format

Somnath_DasSomnath_Das Member Posts: 22  Maven
I am having a column which contains date in the following format:
Apr 1, 2021, 5:30:00 AM GMT+5:30
The datatype of the column is polynomial, I want to convert it into date-time format using the nominal to date operator but is getting the error that "cannot parse date: unparseable date". Please help
Tagged:

Best Answer

  • kaymankayman Member Posts: 651   Unicorn
    edited May 25 Solution Accepted
    The full date format would be MMM dd, yyyy, HH:mm:ss a Z

    If you can ignore the time part (it looks just like midnight UTC) you can also just remove the time part from the date format in the Nominal to date operator. 

    Use MMM dd, yyyy as date format (data type can remain date_time) and select UTC as time zone. This should give the correct result. You can also select a timezone that 5:30 hours ahead, but not sure where that would be.

Sign In or Register to comment.