I have a table filled with a lot of rows and I need to select all the rows that are less than a year old till now.
The table (called orders
) has a DateTime
column named order_date
, that's the field that determines when the order was placed.
How can I select all the records that have an order_date
between now and a full year ago?