<div>
select to_char(sysdate, 'fmYYYY') from dual<br />
<br />
date does not have format, I mean datetime column in database...<br />
<br />
can you please give example showing what are you tryin to do...
</div>


select to_char(sysdate, 'fmYYYY') from dual

date does not have format, I mean datetime column in database...

can you please give example showing what are you tryin to do...

<div>
You need convert Date to Numeric Format like Excel used?...
</div>


You need convert Date to Numeric Format like Excel used?...

<div>
For example 12/23/2008 must be &nbsp;as 2008<br />
<br />
i need to convert the date fromat to numeric and use right function<br />
<br />
<br />
i need to convert a char value to varchar<br />

</div>


For example 12/23/2008 must be  as 2008

i need to convert the date fromat to numeric and use right function


i need to convert a char value to varchar


<div>
In the database the dob is for example given as 12/23/2003 then after writing the query i need to get only<br />
2003. The dob in date datatype and i need to convert it to numeric. I need to write in oracle
</div>


In the database the dob is for example given as 12/23/2003 then after writing the query i need to get only
2003. The dob in date datatype and i need to convert it to numeric. I need to write in oracle

<div>
select to_number(to_char(sysdate,<wbr /> 'fmYYYY')) from dual
</div>


select to_number(to_char(sysdate, 'fmYYYY')) from dual

<div>
Can you please tell me the same way how to convert Char datatype to Varchar2 and numeric to Varchar2
</div>


Can you please tell me the same way how to convert Char datatype to Varchar2 and numeric to Varchar2

<div>
<div class="content wysiwyg-content">
Hello everyone<br />
<br />
I need to convert date with format mm/dd/yyyy to numeric nnnn format<br />
<br />
char to varchar<br />
<br />
in oracle sql query <br />
<br />
Please help<br />
<br />
<br />

</div>
</div>


Hello everyone

I need to convert date with format mm/dd/yyyy to numeric nnnn format

char to varchar

in oracle sql query 

Please help




Please help with Conversion function in sql

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.