Does this do what you need?

SELECT DISTINCT TOP (100) PERCENT Date

FROM dbo.RMMarketPrice

WHERE Date BETWEEN dateadd(mm, datediff(mm, 0, @date), 0) AND

dateadd(dd, datediff(dd, 0, @date) - 1, 0)

ORDER BY Date