SQL: Below SQL will give the age of an employee based on the birthdate.

-



select trunc((to_number(to_char(sysdate,'yyyymmdd'))-to_number(to_char(BIRTHDATE,'yyyymmdd')))/10000) AGE, BIRTHDATE from PS_DEP_BEN WHERE EMPLID = '6508';

Comments

Post a Comment

Popular posts from this blog

PeopleSoft Query Security - Explained

-
PeopleSoft Query Security – Explained   If a PeopleSoft record built through Application designer is not listed in PS-Query tool for reporting, it means that the particular PeopleSoft record is not available for the user to access through PS-Query. For example, one has built a custom record PS_Z_ABC through Application Designer, then the record - Z_ABC won't be available under for PS-Query for any user. The record has to be added to a query tree. Why to add a record to a Query Tree?  How to add a record to Query Tree? Well, PeopleSoft Queries are used to build SQL queries and retrieve information from application tables. For each PeopleSoft Query user, you can specify the records the user is allowed to access when building and running queries. This is done by creating query access groups in PeopleSoft Tree Manager and then assigning users to these query access groups with PeopleSoft Query security. PeopleSoft Query security is enforced only when using PeopleSoft Qu...
Read more