Last Full Month

[fishbone34]

Hello, I'm trying to write a MS-DTS Script that will connect to my Oracle 8i server and download data for the last full month.

In my Table I have a table "SW_CASE" I have a column named: "SWDATECREATED".
It store the data the following way:

2004-09-02 08:57:12

What I need is a way to tell it I Only need the rows from the last full month. I don't want to have to change the date every time I co to run this query.

I've tried the following only to get a syntax error:

SW_CASE."SWDATECREATED" >= DATEADD(mm,DATEDIFF(mm,0,SYSDATE())-1,0) AND
SW_CASE."SWDATECREATED" < DATEADD(mm,DATEDIFF(mm,0,SYSDATE()),0))

Any Ideas?

Fishbone34

[marist89]

You'll need to mess around with add_months and trunc. It will be something like add_months(trunc(sysdate,'mm'),-1) to trunc(sysdate,'mm')-1

[fishbone34]

Thanks Jeff, It works!

fishbone34