Re: help with SQL date coversion

[daniel@xxxxxxxx]

Maybe use „digits“ instead of „char“? AFAIK „digits“ preserves leading zeros in the string.

HTH
Daniel


> Am 16.08.2023 um 18:46 schrieb gio.cot via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx>:
>
> 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 
>
>
>
>
>
> -- 
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.