Top "To-char" questions

The TO_CHAR function converts another data type (e.g. NUMBER, DATE) to a text.

ORACLE convert number to string

Need some help in converting numbers: select to_char(a, '99D99') , to_char(a, '90D99') from ( …

Read More
oracle to-char
Oracle - Number to varchar

I have a table containing a column of type Number create table tmp ( /*other fields*/ some_field Number ) and in …

Read More
oracle plsql to-char
SQL to_char Currency Formatting

I am facing a to_char() currency formatting problem here. The below code is working for me: SELECT TO_CHAR(10000,…

Read More
sql oracle currency to-char
Oracle number and varchar join

I have a query that joins two tables. One table has a column that is of type varchar, and the …

Read More
performance oracle join to-char ora-01722
Oracle Time Comparisons

Is Oracle (10g) doing a proper TIME comparison here, or do I need to convert to decimal time and then …

Read More
sql oracle date-arithmetic to-char
how to display number value in words

Q. Display the number value in Words and output should look like this SAL In_Words --------- ----------------------------------------------------- 800 eight hundred 1600 …

Read More
sql oracle type-conversion to-date to-char
SQL Error: ORA-00932: inconsistent datatypes: expected CHAR got NUMBER

I am trying to have a result 'none' every time it gives me a null result. Right now it is …

Read More
sql oracle sum to-char
How to convert datetime HH:DD:SS AM/PM to HH:DD AM/PM

I have a gridview column, where I need to display time in format : 3/2/2012 1:22 PM but my Db saves as 3/2/2012 1:22:42 PM …

Read More
asp.net datetime oracle10g datetime-format to-char
how to fix oracle ORA-01722 invalid number error

I have Oracle db with these inputs on column1(NUMBER(22,6)) in myTable. 0 199935,15 1026299 I want to display these columns like that: 00000000000000000.000000 00000000000199935.150000 00000000001026299.000000 …

Read More
sql oracle oracle11g to-char
To_Char and T_Number alternate in SQL Server for formatting

What is the SQL Server alternate of To_CHAR([Column_Name], -987654321) To_Number([Column_Name],'999999999D99999900') ? Also, …

Read More
sql-server oracle casting formatting to-char