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.
With the proper format you should be able to use a simple cast to convert to date:
cast([dateasvarchar],date)
use cast function it will convert the datatypes in the report.Syantax is
cast(Expression,datatype_conversion)
Quote from: jahnavi on 11 Jun 2008 06:44:20 AM
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..