DateTime issue at Universe Level

[Former Member]

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

[Former Member · Accepted solution]

No. There is no other alternative. We (usually) set the type for datetime objects to Char.

Best,

Srinivas

[Former Member]

Hi,

Use the Function Convert to convert into datetime format in the Universe object level.

Syntax:

convert(datetime,field_name,101)

Regards,

Shiva Kumar G.C

[Former Member]

Keep it as date, but in the universe apply the format that is desired on the report. You do this by right-clicking on the object and selecting the format option. Set the date/time format that you want. Any new reports using this universe should then take this as the default format. Note: this will not "fix" or affect existing reports in any way.