Timeline for Selecting records where date range is current year minus #years
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 31, 2015 at 14:51 | comment | added | user1822 |
The question is tagged oracle. There is no dateadd() function in Oracle.
|
|
| Jul 31, 2015 at 14:46 | comment | added | Hannah Vernon♦ |
You may want to add details about how to convert that into a DELETE statement, as well.
|
|
| Jul 31, 2015 at 14:44 | comment | added | Hannah Vernon♦ |
Also, instead of using yy as the parameter for DATEADD() you should use the full name, year, since its much more concise and you won't inadvertently shoot yourself in the foot.
|
|
| Jul 31, 2015 at 14:42 | comment | added | Hannah Vernon♦ |
You may want to ensure you understand how BETWEEN works. It's typically easier to understand later on if you use (DateField >= DATEADD(year,-5, GETDATE()) AND DateField <= DATEADD(year, -1, GETDATE()))
|
|
| Jul 31, 2015 at 14:41 | history | edited | Hannah Vernon♦ | CC BY-SA 3.0 |
improved formatting
|
| Jul 31, 2015 at 14:29 | review | First posts | |||
| Jul 31, 2015 at 14:44 | |||||
| Jul 31, 2015 at 14:24 | history | answered | Darren Thompson | CC BY-SA 3.0 |