DATETIME is truncated to Date only

[Former Member]

I have several DATETIME fileds in my Universe that Lumira is truncating to a date level without the time information.  Does anyone know if this is by design, or if there is someway to get the time component?  Thanks!

[som · Accepted solution]

HI Chad

Thanks for the screenshot.

Yes this is currently a limitation. We have it in our backlog to address this.

Sharon

[Former Member · Accepted solution]

Thanks Sharron and Joseph for the quick responses, we use timestamps for events in our FACT table so being able to get to a TIME grain would be a great feature for us.

[Former Member]

Please share date time value format in your load...If it is valid one, please check the data type of the visual column.....

We have 3 data types related to date and time..

1. Date

2.TIme

3.timestamp

Try with timestamp and look for formatting options for changing the display format....