GoFuckYourself.com - Adult Webmaster Forum - View Single Post

Socks · 02-03-2013, 10:47 PM

In one table named AD I have a date_of_birth field, saved like 1970/01/30
In another table named AQ I have quote_date saved like 2009/01/30

I want to create a new column in AD called "age" and save how old they were when they got the quote.

So on January 30th, 2009, they were 39 years old. I want to save "39" to a new field in the same row as date_of_birth.

Important note: Both fields are strings, not date fields. :/

Oracle, but most SQL statements work.. Also doesn't need to be to-the-day accurate.

How do I do this?

02-03-2013, 10:47 PM
Socks Confirmed User Industry Role: Join Date: May 2002 Location: Toronto Posts: 8,475	I need some quick SQL help In one table named AD I have a date_of_birth field, saved like 1970/01/30 In another table named AQ I have quote_date saved like 2009/01/30 I want to create a new column in AD called "age" and save how old they were when they got the quote. So on January 30th, 2009, they were 39 years old. I want to save "39" to a new field in the same row as date_of_birth. Important note: Both fields are strings, not date fields. :/ Oracle, but most SQL statements work.. Also doesn't need to be to-the-day accurate. How do I do this? Last edited by Socks; 02-03-2013 at 10:49 PM..