OraFAQ Forum: Reports & Discoverer » Remove leading zeros from time

Home » Developer & Programmer » Reports & Discoverer » Remove leading zeros from time

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Remove leading zeros from time [message #88531]

Thu, 31 October 2002 11:20

Manish
Messages: 79
Registered: December 2000

Member

Hello,

I'm facing some problem. I want to remove leading zeros from time like 09:00 to 9:00 or 01:45 to 1:45 in Oracle Reports. I have already set the format to HH:MI Am in property pallete. But this gives time with leading zeros.

Please can someone help me.

Thanks
Manish

Report message to a moderator

Re: Remove leading zeros from time [message #88560 is a reply to message #88531]

Sun, 17 November 2002 22:41

Bela
Messages: 1
Registered: November 2002

Junior Member

Hi Manish,
Try this in SQL and the same you can give in the Report Builder, Property palette like fmHH:MI that's it.
SELECT TO_CHAR(SYSDATE,'fmHH:MI') FROM DUAL;

Bela

Report message to a moderator

Previous Topic:	if any field is null in database i want that next field come instead of blank space(by hiding that f
Next Topic:	Can we use Loops in Report Builder Queries

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 16 07:02:25 CST 2025