[go: up one dir, main page]
Scribd
Upload
25 views7 pages

Date Query

The document contains various date queries related to year, month, quarter, day, and age calculations. It includes a list of cricketers with their names and dates of birth, as well as order and ship dates for various transactions. The information is structured in a way that facilitates date-related analysis and comparisons.

Uploaded by

aaryamansh345
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
25 views7 pages

Date Query

The document contains various date queries related to year, month, quarter, day, and age calculations. It includes a list of cricketers with their names and dates of birth, as well as order and ship dates for various transactions. The information is structured in a way that facilitates date-related analysis and comparisons.

Uploaded by

aaryamansh345
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
You are on page 1/ 7

Date Query 1 Year,Month,Quarter,Day,Weekday,Week of Year,Week of Month,Day of Week,Day of Year,Name of

Date Query 2 Start of Year,End of Year,Start of Quarter,End of Quarter,Start of Month,End of Month

Date Query 3 Age

Date Query 4 Difference in Date


Week,Day of Year,Name of Day,Name of Month

nd of Month
Order Date
3/30/1988
2/13/2025
2/8/2024 Year Year,Month,Quarter,Day,Weekday,Week of Year,Week of M
1/8/2021 Month
3/18/2019 Quarter
12/12/2019 Day
1/10/2020 Weekday
8/26/2021 Week of Year
2/14/2024 Week of Month
1/2/2020 Day of Week
1/25/2020 Day of Year
Name of Day
Name of Month
day,Week of Year,Week of Month,Day of Week,Day of Year,Name of Day,Name of Month
Order Date
3/30/1988
2/13/2025
2/8/2024
10/31/2019
3/18/2019
12/12/2019
1/10/2020
8/26/2021
2/14/2024
1/2/2020
1/25/2020
Cricketers Players Name Date Of Birth
Sachin Tendulkar 4/24/1973
MS Dhoni 7/7/1981
Virat Kolhi 11/5/1988
Amit Mishra 11/24/1982
Bhuvneshwar Kumar 2/5/1990
Cheteshwar Pujara 1/25/1988
Deepak Chahar 8/7/1992
Dinesh Karthik 6/1/1985
Hanuma Vihari 10/13/1993
Ajinkya Deshmukh 12/16/1989
Order Date Ship Date
12/4/2025 1/11/2026
12/7/2024 2/8/2025
7/23/2025 10/9/2025
1/25/2022 2/18/2022
1/23/2021 4/2/2021
5/20/2024 6/10/2024
11/29/2020 1/27/2021
10/17/2022 11/8/2022
10/27/2021 12/23/2021
12/4/2021 2/19/2022

You might also like