How to Change the Varchar2 Data type to date for a data item.

[S_N_Solution]

I have two columns in report having varchar2 data type(Date enter as Varchar2).Now i want to subtract those columns and want to show the duration between those time.But because data is entered as Varchar2,i am not able to calculate this value.Please suggest me how should i get the difference between those columns.

[blom0344]

With the proper format you should be able to use a simple cast to convert to date:

Code Select Expand


cast([dateasvarchar],date)


[jahnavi]

use cast function it will convert the datatypes in the report.Syantax is

cast(Expression,datatype_conversion)

[blom0344]

use cast function it will convert the datatypes in the report

Please take note of earlier replies. You are just echoing my response.
Add or correct it instead of repeating it's contents..