Forum

Share:

Notifications

Clear all

How to Write a SQL Query to get all people born on the same day and month excluding the year?

Last Post

RSS

<img alt='' src='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=80&r=g&d=mm' srcset='//www.gravatar.com/avatar/38776ecf23daaf8d2b881408fc55fc47?s=80&r=g&d=mm 2x' class='avatar avatar-80 photo' height='80' width='80' decoding='async'/>

Posts: 47

Pavan NJ

Guest

Topic starter

Jul 28, 2020 6:51 am

(@Pavan NJ)

Eminent Member

Joined: 3 years ago

Given Date is 10th October

Topic Tags

sqlquerypeopleborn sameday samemonth excludingyear

1 Reply

<img alt='' src='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=80&r=g&d=mm' srcset='//www.gravatar.com/avatar/145acdc57a7ca44c99fa14d88bdddeb8?s=80&r=g&d=mm 2x' class='avatar avatar-80 photo' height='80' width='80' decoding='async'/>

Posts: 36

Sandeep0069

Guest

Jul 28, 2020 10:58 am

(@Sandeep0069)

Eminent Member

Joined: 3 years ago

You have to use both day and month function. Try the below query.

Select Name, DateOfBirth, CAST(DateOfBirth as Date) as [DatePart]

From Employees

Where Day(DateOfBirth)=10 AND Month(DateOfBirth)=10

Hope it helps.

This post was modified 2 years ago by KV Kumar

Reply

Leave a reply

Share:

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 Tags

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo version 2.2.2