Here’s a great article that should help you build your algorithm http://www.codeproject.com/KB/datetime/christianholidays.aspx Based on this example, you should be able to write: DateTime goodFriday = EasterSunday(DateTime.Now.Year).AddDays(-2); Full Example: public static DateTime EasterSunday(int year) { int day = 0; int month = 0; int g = year % 19; int c = year / 100; int … Read more
Others have commented on the (incorrect) use of 2/11 to specify the desired interval. I personally however prefer writing things like that using ANSI interval literals which makes reading the query much easier: sysdate – interval ‘2’ hour It also has the advantage of being portable, many DBMS support this. Plus I don’t have to … Read more
SELECT DATE_PART(‘days’, DATE_TRUNC(‘month’, NOW()) + ‘1 MONTH’::INTERVAL – ‘1 DAY’::INTERVAL ) Substitute NOW() with any other date.
Here’s a great article that should help you build your algorithm http://www.codeproject.com/KB/datetime/christianholidays.aspx Based on this example, you should be able to write: DateTime goodFriday = EasterSunday(DateTime.Now.Year).AddDays(-2); Full Example: public static DateTime EasterSunday(int year) { int day = 0; int month = 0; int g = year % 19; int c = year / 100; int … Read more
Try something like: update salereg1 set expdate = current_date + interval ‘1 month’ * numberofmonths;
Use: SELECT * FROM YOUR_TABLE WHERE creation_date <= TRUNC(SYSDATE) – 30 SYSDATE returns the date & time; TRUNC resets the date to being as of midnight so you can omit it if you want the creation_date that is 30 days previous including the current time. Depending on your needs, you could also look at using … Read more
Try adding months (12 * number of years) instead. Like this- add_months(date’2010-10-10′, 48)
In addition to being able to add a number of days to a date, you can use interval data types assuming you are on Oracle 9i or later, which can be somewhat easier to read, SQL> ed Wrote file afiedt.buf SELECT sysdate, sysdate + interval ’30’ minute FROM dual SQL> / SYSDATE SYSDATE+INTERVAL’30’ ——————– ——————– … Read more