0

How to get the date

i want to get the value above the 15th of every month. in sql. so how to get this.. for exam.. i have a task.. where some account in table.. so i want to display the that account which open the after 15th of each month.. so plz tell me how to do it. Thanks in advance .

16th Mar 2017, 3:37 PM
Pratul Tripathi
Pratul Tripathi - avatar
2 odpowiedzi
+ 1
For sql server 2008+ SELECT acount FROM YourTable WHERE DAY(yourDateColumn) > 15
5th Apr 2017, 7:09 AM
Matej Hlavaj
Matej Hlavaj - avatar
0
thanks buddy
5th Apr 2017, 10:53 PM
Pratul Tripathi
Pratul Tripathi - avatar