date calculation - 12th of last month

[galaxy0815]

Hi,

Can you please let me know if there is an easier way of calculation from todays date the 12.th of last month as this one here:

date(trim(Char(YEAR(CURRENT DATE - 1 MONTH)))||'-'|| trim(Char(MONTH(CURRENT DATE - 1 MONTH)))||'-12')

Looks so complex for this simple task. Thanks

 

[papadba]

That appears reasonably "easy" to me?

What might you prefer? As long as you only want 12th of last month (from today - either before or after midnight) what you hae should sufice.

 

[notadba]

You could go 'slightly' easier with:

SELECT CURRENT DATE - 1 MONTH - DAY(CURRENT DATE)DAYS + 12 DAYS
FROM SYSIBM.SYSDUMMY1

Which at least keeps everything as a date through the calculation.... but gets you the same result.

 

[galaxy0815]

Thanks!