Showing results for 
Search instead for 
Did you mean: 

Display TIME in BEx query

Former Member
0 Kudos

Hello Guys,

I have time field in my query ( Arrival Time : 13:00:00).

but when i run the query, its displaying as only '1' instead of 13:00:00.

Could please tell me, how to display the actual value in the field in the report.


BI Consultant

Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

can you just try out by creating new formula TIME(KF).

TIME (process value as time) function is available under data functions of fomrula builder.

if your InfoObject is characteristics,create a formula variable on it use TIME function.

Message was edited by:


Former Member
0 Kudos

Hello Murali,

Thanks very much for your reply.

its displaying ok , when i have the time value.

Its not displaying anything if the time is 00:00:00.

Could you please help me how to display the above value.


BI Consultant