« previous next »
Pages: [1]

Author Topic: Date Question  (Read 3967 times)

jaxmudd

  • Newbie
  • *
  • Posts: 1
    • View Profile
Date Question
« on: February 14, 2011, 09:02:13 am »
Hello, In Oracle I am looking for the most efficent way to say...If today is monday give me Friday-Sunday, if it is not Monday give me the previous days date. I have seen something close in a where clause with a case but I just can't get the syntax correct.

Thanks in advance
Logged

Mike

  • Administrator
  • Hero Member
  • *****
  • Posts: 1812
    • View Profile
Re: Date Question
« Reply #1 on: February 15, 2011, 08:39:42 pm »
Can you explain a little more clearly what it is that you're trying to achieve?

Also, do you want SQL or PL/SQL?

Quote from: jaxmudd on February 14, 2011, 09:02:13 am
Hello, In Oracle I am looking for the most efficent way to say...If today is monday give me Friday-Sunday, if it is not Monday give me the previous days date. I have seen something close in a where clause with a case but I just can't get the syntax correct.

Thanks in advance
Logged
Pages: [1]
« previous next »