Hi,
I have converted the seconds stored in the database in to HH:MM:SS format. Below is the syntax.
to_char(trunc(Table name.Column name / 60 / 60), β09β) || to_char(trunc(mod(Table name.Column name, 3600) / 60), β09β) || to_char(mod(mod(Table name.Column name, 3600), 60), β09β)
The same above login needs to be done at the reporting level(WebiXIR2). We have trunc and mod function in bo but we donβt have to_char function in bo.
Any one help me to convert the above logic in WEBIXIR2 report.
Thanks,
stalint (BOB member since 2004-12-14)