« Enterprise Architect (EA) – UML model with Use Case Metrics – pragmatic approach
With Oracle10g Database many new features on case-, accent- and linguistic idependent query and sort functions »
You might also like
| using the anydata datatype in oracle -------------------------------------------------------------------------------- -- sys.anydata.sql -------------------------------------------------------------------------------- --... | I’m A Celebrity, GET ME out OF here! Julia showing skin and Isabel as she was created by God – You dont’t have to hide a pretty body I’m A Celebrity, GET ME out OF here! You dont't have to hide a pretty body.... Isabel as she was... | Naming and Coding Standards for SQL and PL/SQL – Some things I cant agree As written by William Robertson (based on Steven Feuerstein), by using coding standards supports... | Offering for Oracle 7.2.3 DDL scripts – show objects with Enlighten Thank you for your CAST application mining inquiry. Enclosed we send a commercial offer to you as... |

















February 10th, 2009 - 21:46
I’m looking for code to determine the “2nd Friday of the month” and I found this:
select next_day(sysdate,’FRIDAY’) as NEXT_DAY from dual
however, this prints the next Friday, not the 2nd Friday.
Thought I’d share.
May 19th, 2010 - 05:30
SELECT DATE(DATE_ADD(‘2010-05-21′, INTERVAL 6 – DAYOFWEEK(‘2010-05-21′) DAY))
May 19th, 2010 - 05:41
there is a small mistake, because saturdays are considered same week. solution is to add 1 day to the date you wanna check:
SELECT
DATE(
DATE_ADD(
‘2010-05-19′ + INTERVAL 1 DAY,
INTERVAL 6 – DAYOFWEEK(‘2010-05-19′ + INTERVAL 1 DAY) DAY
)
)