Oracle

[Graham Thorpe]

Hi all

I facing one oracle query problem ..

In one table i have one column named "today_date" as type varchar;
And another table i have another column named"cf_Auth_dt" as type date.
So i need to substract these dates .
Can any body give idea !!!
Thanks and Regards
Reddy

[Wayne L Johnson]

I tried to do a simple subtract on a table with two dates (in Oracle) and it seems to return a real value representing the number of days/hours [eg., 12.75 = 12.75 days, or 12 days and 18 hours]. So you just have to convert the varchar date into a date field. Something like this:

Select table1.today_date, table2.cf_auth_dt,
       to_date(table1.today_date,'mm/dd/yyyy') - table2.cf_auth_dt
  From table1, table2
 Where table1.xxx = table2.yyy

You need to specify the correct format for the varchar date [however it's stored in the database], and the rest should be fairly obvious. This is how it's done in SQL.