Scribd
Upload
21 views3 pages

DATEDIFF Function

The document contains employee information including their IDs, names, and join dates, as well as customer order details with order IDs, customer names, order dates, and delivery dates. Additionally, it provides employee attendance records showing in and out times for a specific date. The data reflects a range of employees and customer interactions over various dates.

Uploaded by

shobha m
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
21 views3 pages

DATEDIFF Function

The document contains employee information including their IDs, names, and join dates, as well as customer order details with order IDs, customer names, order dates, and delivery dates. Additionally, it provides employee attendance records showing in and out times for a specific date. The data reflects a range of employees and customer interactions over various dates.

Uploaded by

shobha m
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

E ID Employee Name Join Date

E001 Emma 30-Mar-20


E002 James 19-Nov-22
E003 Olivia 23-Aug-16
E004 Michael 21-Jan-24
E005 Ava 19-Mar-15
E006 William 7-Feb-25
E007 Sophia 18-Jun-21
E008 Ethan 26-Feb-21
E009 Isabella 8-Feb-22
E010 Jacob 25-Nov-16
Order ID Customer Name Order Date Delivery Date
O12 Customer A 4/1/2025 4/3/2025
O15 Customer B 4/8/2025 4/9/2025
O17 Customer C 4/4/2025 4/8/2025
O33 Customer D 4/2/2025 4/5/2025
O22 Customer E 4/1/2025 4/3/2025
O17 Customer F 4/2/2025 4/7/2025
O21 Customer G 4/4/2025 4/6/2025
O45 Customer H 4/7/2025 4/10/2025
O62 Customer I 4/6/2025 4/11/2025
Employee Name In time Out Time
Emma 4/11/25 10:00 AM 4/11/25 3:30 PM
James 4/11/25 9:35 AM 4/11/25 4:00 PM
Olivia 4/11/25 11:45 AM 4/11/25 4:00 PM
Michael 4/11/25 10:15 AM 4/11/25 5:10 PM
Ava 4/11/25 8:00 AM 4/11/25 5:00 PM
William 4/11/25 1:30 PM 4/11/25 6:00 PM
Sophia 4/11/25 11:30 AM 4/11/25 4:25 PM

You might also like