How to get the date

Question

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 .

Answer 1

For sql server 2008+

SELECT acount
FROM YourTable
WHERE DAY(yourDateColumn) > 15

Answer 2

thanks buddy