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
kang
Messages: 89
Registered: November 2007
Member
strange to_char result.
select length(to_char(12,'0000')) from dual
why this gives 5 not 4 ?
TIA.
Re: strange to_char result. [message #344530 is a reply to message #344529] Sat, 30 August 2008 04:26 Go to previous message
Frank
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: Mon Dec 05 21:15:15 CST 2016

Total time taken to generate the page: 0.09397 seconds