AS400: Timestamp to yyyy-mm-dd (ISO)

select Char(date(Now()), iso) from sysibm/sysdummy1

Output 
2017-12-18

select date(Now()) from sysibm/sysdummy1

Output
12/18/17

Comments

Popular posts from this blog

AS400 : Add a new line in text in email SNDSMTPEMM

AS400 Display: Radio Button (SNGCHCFLD)

AS400 Display File: Check Box (MLTCHCFLD)