to_cahr with format

bmo_atolcd · Post by **bmo_atolcd** » Thu 12 Apr 2012 08:51

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

Shalex · Post by **Shalex** » Thu 12 Apr 2012 13:54

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')).

Shalex · Post by **Shalex** » Mon 02 Jul 2012 06:52

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.

Shalex · Post by **Shalex** » Thu 19 Jul 2012 10:02

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 .

Devart Forums

to_cahr with format

to_cahr with format

Re: to_cahr with format

Re: to_cahr with format