Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to show Late Coming and Early going through SQL or PL/SQL

Kam__apexJun 22 2020 — edited Jun 24 2020

Dear Freinds,

I want to mention "Late Coming and Early Going" in my data through SQL.

Below is query to get the time.

SELECT TO_char(TIMEIN,'HH24:MI') TIMEIN,TO_char(TIMEOUT,'HH24:MI') TIMEOUT from ATTENDANCE

TIMEIN      TIMEOUT    

08:00          17:15          

08:13           17:02        

08:25           17:00         

Data is like above. I want if the timein is above 08:00 its should be marked as "Late" in status field and same should be with the timeout if time is before 17:00 it should be marked as "Early".

Please help.

Regards

Kam
This post has been answered by mathguy on Jun 22 2020
Jump to Answer
Comments
Post Details
Added on Jun 22 2020
16 comments
10,872 views