WitchyRed Posted June 16, 2003 Share Posted June 16, 2003 How do I go about converting a date of birth field to age?? Link to comment Share on other sites More sharing options...
vcant Posted June 16, 2003 Share Posted June 16, 2003 since my my computer doesnt work, and im on the other one i can not test it and give you the exact answer, but it should go somethig like that:select (now-bdate) as age..... Link to comment Share on other sites More sharing options...
WitchyRed Posted June 16, 2003 Author Share Posted June 16, 2003 where would I enter that? Link to comment Share on other sites More sharing options...
vcant Posted June 16, 2003 Share Posted June 16, 2003 ok, let say you making a new querythen you put it like this:select (now - bdatecolumn) as myagefrom mytable Link to comment Share on other sites More sharing options...
WitchyRed Posted June 16, 2003 Author Share Posted June 16, 2003 Thank You! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now