Jul 27, 2020 12:00 pm
Hi Please answer this question How to get age from the dob column?
1 Reply
Jul 27, 2020 1:31 pm
SELECT
TRUNC((SYSDATE - TO_DATE(DOB, 'YYYY-MM-DD'))/ 365.25) AS AGE_ASOFTODAY FROM DUAL;
It is one of the easiest way to write a query to achieve this requirement.
Leave a reply
Forum Statistics
10
Forums
174
Topics
321
Posts
0
Online
1,386
Members
Latest Post: Query Optimization: A Comprehensive Guide for Stored Procedures Our newest member: anjalirrb Recent Posts Unread Posts
