Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Age Formulas using SQL
Summary
Need age as of the current date and when someone will be a certain ageContent
Hello,
I am needing a formula to calculate age in Years that does NOT round. For example, if someone's age is 38.6 as of the current date I don't want it to round up to 39.
I am also needing a formula to calculate when someone will be 65. I can do the EDATE function in Excel but can't figure out what to use as a formula in SQL.
Thanks!
0