RE: [sqr-users] currentdate - one month

["Chu, Nicholas" <Nicholas.Chu@RedPrairie.com>]

Wouldn't it be easier to use database functions?
In Oracle 9, can use add_months function:

select add_months(sysdate, -1) from dual;



-----Original Message-----
From: sqr-users-bounces+nicholas.chu=redprairie.com@sqrug.org
[mailto:sqr-users-bounces+nicholas.chu=redprairie.com@sqrug.org] On Behalf
Of radhika reddy
Sent: Thursday, September 09, 2004 10:15 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] currentdate - one month

Hi,

    I am not getting how to get one month prior to current date in SQR.

Thanks,
Radhika

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users