Month relative

[ShortyA]

Hi there,
I am trying to write a script that extracts data where a date field contains a value that is from the last full month.

Does anyone have any guidance on the syntax ?
Thanks very much,
Alec

 

[ARWinner]

Alec,

How about:

Select * from mytable where month(mydate) = month(current date - 1 MONTH)

HTH

Andy

 

[sathyarams]

Is this what you are looking for :

values(current date - day(current date) days +1 day - 1 month)

1
----------
04/01/2003

1 record(s) selected.


values (current date - day(current date) days )

1
----------
04/30/2003

1 record(s) selected.

More DB2 questions answered at

http://www.dbforums.com/f8

 

[ShortyA]

Thanks for your help. I used the suggestion from ARWinner and it was exactly what I needed.

Alec