caramelkaps (4/10/2012)

---

Hi,

We have a very time sensitive pressing requirements to be addressed immediately.

We need to read the date time column from sql server into oracle 10g.

We have a dblink established...

Try replacing your date filter with this:

AND (IND2.DEMAND_DATE >= dateadd(mm, datediff(mm, 0, getdate()) - 2, 0) AND IND2.DEMAND_DATE < dateadd(mm, datediff(mm, 0, getdate()) - 1, 0))

Your BETWEEN will not work.

select DATEADD(month,-2,DATEADD(D, -1, DATEADD(M,DATEDIFF(M,0,GETDATE())+1,0))) , DATEADD(month,-2,DATEADD(DD, 1 - DAY(GETDATE()), GETDATE()))

Results:

The first date is greater than the second.

Looking at the dates you tried to calculate, I'd say you are looking for the start and end for 2 months ago.

Here is some code to help you:

declare @ThisDate datetime,

...

Looking at the code you did post, you'd get nothing in return any way. It looks like the first date is > the second date. Using BETWEEN the...

twdavis-893252 (4/10/2012)

---

I can't get the Convert or Cast to work please help

DATEADD(month,-3,DATEADD(D, -1, DATEADD(M,DATEDIFF(M,0,GETDATE())+1,0)))

for use in a between statment like

DEMAND_DATE BETWEEN DATEADD(month,-2,DATEADD(D, -1, DATEADD(M,DATEDIFF(M,0,GETDATE())+1,0)))

AND DATEADD(month,-2,DATEADD(DD, 1 - DAY(GETDATE()),...

Do some reading on HAVING in Books Online.

ColdCoffee (4/10/2012)

---

Lynn/Capt.Hector , correct me if i am wrong, we dont need DATEADD+DATEDIFF in the GROUPBY/ORDER BY; just DATEDIFF would do.

Why i say this, SQL needs to just to wrap...

Let us know if you get...

Edit: --- Ignore, doesn't work (yet) ----

Here is my shot at the code:

select

substring(convert(varchar(24), dateadd(mm,datediff(mm,0,datefield),0), 113),4,8), count(*)

from

dbo.MyTable

group by

dateadd(mm,datediff(mm,0,datefield),0)

order...

Interview question?

Care to post what you have tried so far?

later!

long-haul

Please don't double post. Most people that answer these forums use the Active Threads view to see what is currently being posted. In addition it fragments any responses...