Select with date over 20 years

Asked

Viewed 372 times

2

How to make a select with date of request greater than 20 years old?

Select * 
from Pedidos
Where dataPedido > ...
sql-server

1 answer

6


Select * 
from Pedidos
Where dataPedido > DATEADD (yy, -20, GETDATE());

See more here.

Browser other questions tagged sql-server

You are not signed in. Login or sign up in order to post.