Re: varchar_format illegal on customer box?

[Dan <dan27649@xxxxxxxxx>]

We're still on 7.1.  I can confirm that the examples in your OP won't work
on our box, but
> select dec(varchar_format(
> timestamp_iso(current_date), 'YYYYMMDD'),8,0)
> from sysibm.sysdummy1
does work.

- Dan

On Tue, Mar 20, 2018 at 9:18 AM, Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
wrote:

> Thx Rob - i think i narrowed it down to we are on 7.2 and client is 7.1 or
> less...
>
> in 7.1 or less, I believe the answer is to refer to a timestamp initially
> and not a date, such as...
>
> select dec(varchar_format(
> timestamp_iso(current_date), 'YYYYMMDD'),8,0)
> from sysibm.sysdummy1
>
> At least I found this through some googling which solved the problem for
> one person on 7.1.
>
> If anyone can confirm this it would be appreciated.