Home » SQL & PL/SQL » SQL & PL/SQL » strange to_char result. (10g)
strange to_char result. [message #344529] Sat, 30 August 2008 04:09 Go to next message
Messages: 89
Registered: November 2007
strange to_char result.
select length(to_char(12,'0000')) from dual
why this gives 5 not 4 ?
Re: strange to_char result. [message #344530 is a reply to message #344529] Sat, 30 August 2008 04:26 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
Because of the space it leaves for the leading minus.
Use 'fm0000' to remove that
Previous Topic: Log All Mails Send by Database Server Using UTL_SMTP
Next Topic: Need suggestion
Goto Forum:

Current Time: Thu Jul 27 09:59:15 CDT 2017

Total time taken to generate the page: 0.10304 seconds