How do I select records less than 1 year old...

Question

Howdy,

this should be a fairly simple question but I know very little about SQL. I have a database which has the following fields:

client_id, scheduled_amount, deposit_amount, message_code_id, note_text, system_date

now I wish to select all the records that are less than 1 year old from when the sql statement is run. I know I should use DateDiff, anyone got any ideas?

Thanks

Answer 1

select *
from MyTable
where MyDate > DATEADD(year, -1, GetDate())

Answer 2

TRY

SELECT * FROM TABLE_NAME WHERE SYSTEM_DATE > DATEADD(YYYY, -1, GETDATE())

(UNTESTED)