How do I select records less than 1 year old

[Originally posted by] : http://stackoverflow.com/questions/3652099/how-do-i-select-records-less-than-1-year-old

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

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s