Re: An easy (I think) SQL question

[CRPence <crpbottle@xxxxxxxxx>]

On 29-Jun-2016 10:26 -0500, Rob Berendt wrote:
> Using the CURRENT_DATE - (DAY(CURRENT_DATE) - 1) days - 3 months
> works
>
> But I usually use
> last_day(current_date) + 1 day - 4 months
>
> It'd be nice if IBM added a FIRST_DAY

  While I agree, for the ease of having the built-in already there and 
generally available, there is little point lamenting the lack of 
something so easily done oneself:

   create function first_day
   ( inpDate date
   ) returns date
   language sql
   deterministic
   return
     insert( char( inpDate, ISO ), 9, 2, '01' )
   ;