I'm trying to get a date from SQL without the year. Every code I've seen has included the year. Here is what I have now.
SELECT * , convert(CHAR, \"date\", 10) AS ndate from dbo.MYDB where 35 > DATEDIFF(d,\"date\", GETDATE())";
I would like ndate to be show like mm-dd with now year.