Re: help with SQL date coversion

[Peter Dow <petercdow@xxxxxxxxx>]

The problem might be the char() function.  I think varchar_format is 
expectiing a varchar, not a char.

Both of these work:

values dec(varchar_format(to_date('150923','DDMMYY'),'YYMMDD'),6)

values dec(varchar_format(to_date('050923','DDMMYY'),'YYMMDD'),6)

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx
pdow@xxxxxxxxxxxxxx t/

On 8/16/2023 9:46 AM, gio.cot via RPG400-L wrote:
> Hi all
>
> In a program i found this function that convert data from DDMMYY to YYMMDD
> or vice versa.
>
> If i run this :
>
> values dec(varchar_format(to_date(char(150923), 'DDMMYY'),  'YYMMDD'),6) ;
>
> it works
>
> if i run this :
>
> values dec(varchar_format(to_date(char(050923), 'DDMMYY'),  'YYMMDD'),6) ;
>
> it DON'T work
>
> how can i  solve this problem ? i think that the problem was caused from the
> first zero in the 050923,  that came converted to blank ??!!
>
>   
>
> Thanks in advance
>
>