When I try running this...
select DATEADD(MONTH, DATEDIFF(MONTH, -1, GETDATE())-1, -1) from
sysibm.sysdummy1;
I get the error ... Message: [SQL0204] GETDATE in *LIBL type *N not found.
Cause . . . . . : GETDATE in *LIBL type *N was not found.
If you try running just the statement ...
select DATEADD(MONTH, DATEDIFF(MONTH, -1, GETDATE())-1, -1)
you get the error regarding <END-OF-STATEMENT> -
This is not a complete statement.
We are on V7R2.
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Hoteltravelfundotcom
Sent: Thursday, October 22, 2015 11:57 AM
To: Midrange Systems Technical Discussion
Subject: Need simple SQL to get the last day of month of previous month
HI this code is not working on i.
select DATEADD(MONTH, DATEDIFF(MONTH, -1, GETDATE())-1, -1)
error Message: Token <END-OF-STATEMENT> was not valid. Valid tokens: + - AS
<IDENTI
What would be the syntax for such a select statement?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
