How can I ?????????????
-
HI, In my database i am storing the date of birth of each user, but how can i create a query which give date of births of all user whose birthday month falls in the current month. that means if current month is march then the query should fetch the records of all users which are born in march. :confused::confused::confused::confused:
-
HI, In my database i am storing the date of birth of each user, but how can i create a query which give date of births of all user whose birthday month falls in the current month. that means if current month is march then the query should fetch the records of all users which are born in march. :confused::confused::confused::confused:
Suppose create table TestBirth ( UserId int identity(1,1) ,UserName varchar(50) ,birthday datetime ) is the table which contains the records UserId UserName birthday 1 Manoj Singh 2008-02-02 00:00:00.000 2 Manoj singh2 1894-07-03 00:00:00.000 4 Anshu singh 1894-07-04 00:00:00.000 5 Garima singh 1894-07-13 00:00:00.000 6 Rajan singh 1894-07-14 00:00:00.000 7 Garima chaudhary 1894-07-03 00:00:00.000 8 Pankaj chaudhary 2008-03-03 00:00:00.000 Below query will help you Select UserName from testbirth where Month(birthday) = month(getdate())
Sarvesh Upadhyay Senior Software Engineer Birlasoft India Ltd. Microsoft Certified Professional Developer in Dotnet 2.0 Enterprise Application
-
HI, In my database i am storing the date of birth of each user, but how can i create a query which give date of births of all user whose birthday month falls in the current month. that means if current month is march then the query should fetch the records of all users which are born in march. :confused::confused::confused::confused: