Community & Support
Learn
Marketplace
Discussions
Categories
Discussions
General
Platform
Academic
Partner
Regional
User Groups
Documentation
Events
Altair Exchange
Share or Download Projects
Resources
News & Instructions
Programs
YouTube
Employee Resources
This tab can be seen by employees only. Please do not share these resources externally.
Groups
Join a User Group
Support
Altair RISE
A program to recognize and reward our most engaged community members
Nominate Yourself Now!
Home
Discussions
Community Q&A
Convert polynomial to date format
Somnath_Das
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
Find more posts tagged with
AI Studio
Dates + Times
Accepted answers
kayman
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.
All comments
kayman
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.
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)
Groups
