File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle" Watch "Oracle" New topic


Graham Thorpe
Ranch Hand

Joined: Mar 25, 2002
Posts: 265
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
Wayne L Johnson
Ranch Hand

Joined: Sep 03, 2003
Posts: 399
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:

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.
I agree. Here's the link:
subject: Oracle
jQuery in Action, 3rd edition