Skip to Content
0
Former Member
Feb 10, 2011 at 05:11 PM

DateTime issue at Universe Level

254 Views

Hello Experts,

We have stored date in database as datetime format. In Universe, we have created object on this date. But we have to keep type of this objet as u2018Dateu2019 as there is no datetime object type available in universe.

When we dragged this objet in webi, we found that we are getting only date but no timestamp. We can manually do this using report formatting. However we would like to achive this at universe level.

My question is : What should be the type of object in universe for getting datetime at report level ?

We found that, if we keep objet type as char, we may get the desired results. However is there any other alternative?

Regards,

Chinmay