permaculture playing cards*
The moose likes JDBC 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
Bookmark "Oracle" Watch "Oracle" New topic
Author

Oracle

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
Reddy
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: http://aspose.com/file-tools
 
subject: Oracle