Re: Need simple SQL to get the last day of month of previous month

On 22-Oct-2015 10:57 -0500, Hoteltravelfundotcom wrote:

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?

Presumably the expression intends to yield a DATE value?

An expression that obtains the last day of the prior month would be:

LAST_DAY(CURRENT DATE - 1 MONTH)

But because likely the unstated system-level being used is [probably still] v5r4, an alternate expression would be available as:

CURRENT DATE - DAYOFMONTH(CURRENT DATE) DAYS