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

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
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
It's not a secret anymore!