Select with date greater than 20 years

Question

Navigation

#1 by (6 votes)

2

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

Select * 
from Pedidos
Where dataPedido > ...

sql-server

asked by anonymous 02.06.2016 / 22:33

1 answer

Locate in Delphi Extract name and last name mysql

score 6 · Accepted Answer

6

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

02.06.2016 / 22:40