Page 1 of 1

to_cahr with format

Posted: Thu 12 Apr 2012 08:51
by bmo_atolcd
How do to_char(33.23,'TM') with devart OracleFunctions ?
I need to convert decimal with a specific format.

There is no way to do it with Devart.Data.Oracle.Entity.OracleFunctions.ToChar :(

Posted: Thu 12 Apr 2012 13:54
by Shalex
Please try

Code: Select all

Devart.Data.Oracle.Entity.OracleFunctions.ToChar((decimal)33.23,"TM")
This results in the following SQL: (TO_CHAR(33.23, 'TM')).

Re: to_cahr with format

Posted: Mon 02 Jul 2012 06:52
by Shalex
Overloads for the ToChar/ToNchar methods of the OracleFunctions class are added.
We will post here when the corresponding build of dotConnect for Oracle is available for download.

Re: to_cahr with format

Posted: Thu 19 Jul 2012 10:02
by Shalex
New version of dotConnect for Oracle 7.1 is released!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=24522 .