Home » Developer & Programmer » Reports & Discoverer » Remove leading zeros from time
Remove leading zeros from time [message #88531] Thu, 31 October 2002 11:20 Go to next message
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
Re: Remove leading zeros from time [message #88560 is a reply to message #88531] Sun, 17 November 2002 22:41 Go to previous message
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
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:
  


Current Time: Thu Mar 28 21:11:27 CDT 2024