to_cahr with format

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
bmo_atolcd
Posts: 1
Joined: Thu 12 Apr 2012 08:28

to_cahr with format

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
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

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
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Re: to_cahr with format

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
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Re: to_cahr with format

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 .

Post Reply