GoFuckYourself.com - Adult Webmaster Forum - View Single Post

sarettah · 02-04-2013, 07:43 AM

What you want is the same as the DateDiff() function in sql server but Oracle does not have a DateDiff function.

Here is a solution I found for getting days, hours, minutes: http://asktom.oracle.com/pls/asktom/...42712657900129

I would usually use a DateDiff() that returned months and then divide them by 12 to get the age. Not sure of the best way to do that in Oracle.

As far as the dates being strings you should be able to cast them as dates.

Hope that helps.

.

02-04-2013, 07:43 AM
sarettah see you later, I'm gone Industry Role: Join Date: Oct 2002 Posts: 14,073	What you want is the same as the DateDiff() function in sql server but Oracle does not have a DateDiff function. Here is a solution I found for getting days, hours, minutes: http://asktom.oracle.com/pls/asktom/...42712657900129 I would usually use a DateDiff() that returned months and then divide them by 12 to get the age. Not sure of the best way to do that in Oracle. As far as the dates being strings you should be able to cast them as dates. Hope that helps. . __________________ All cookies cleared! Last edited by sarettah; 02-04-2013 at 07:46 AM..