Report shows date instead of datetime on Webi export?

user_17025152 0
Viewed 47

I am using Web Intelligence for reporting however, the SQL script i use runs fine within Oracle where it displays the date and time of a column.

But when i run this report through web intelligence and then export, it only displays the date.

I am probably missing something incredibly easy but I cant see it.

webi datetime-format oracle mysql
1 Answers

All you should have to do is explicitly set a format rather than leaving it as the default format.

enter image description here

And I get this...

enter image description here

user_6325370
Related