to_cahr with format

to_cahr with format

Postby 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 :(
bmo_atolcd
 
Posts: 1
Joined: Thu 12 Apr 2012 08:28

Postby 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
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Re: to_cahr with format

Postby 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
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Re: to_cahr with format

Postby 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 .
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle