where datetime_column >= Dateadd(Month, Datediff(Month, 0, DATEADD(m, -6, current_timestamp)), 0)
SELECT * FROM MyTable WHERE create_date > DATEADD(mm, -6, GETDATE())
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)