Home » SQL & PL/SQL » SQL & PL/SQL » Re: converting 2.635E+36 to number
Re: converting 2.635E+36 to number [message #20643] Mon, 10 June 2002 14:06
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
in what format is the date stored? if it already stored as varchar2 then

SQL> ed
Wrote file afiedt.buf

  1* select * from test4 where id='2.635E+36'
SQL> /

no rows selected

SQL> ed
Wrote file afiedt.buf

  1* select * from test4 where id=to_number('2.635E+36' )
SQL> /

ID
----------
2.635E+36

Report message to a moderator

Previous Topic: URGENT - select problem
Next Topic: select result (by page)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 18:53:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.