select based on previous date value

sagarh · #1 (**permalink**) 02-27-04, 18:33

I want to do a select statement based on the previous twelve months is there a way I can tell SQL to look back 12 months based either on a field value which is date time field or on the system date value?

r937 · #2 (**permalink**) 02-28-04, 00:32

well, when you think about it, you'd need both, the field datetime value and the system current datetime value

PHP Code:


			
select foo, bar, datetimefield

  from yourtable

 where datetimefield >= current_date - interval 12 month

Internet Services

Web Development

Digital Marketing

Consumer Tech