Convert Date To Char Rpgle, rpgle Converting between Character and Date SQL supports two ways to convert non-date content to a true DATE data type. Purpose: converts a date contained in a date data type to a date contained in a character field Input: (1) date data type; (2) desired format value of the output first use the %char built in function to convert the numeric format date field to character. If you do not specify a value, %DATE() will Wednesday, March 18, 2015 Char built in function added to CL IBM i 7. They do the same thing, convert numbers, dates, and %CHAR can convert the value of a date, time, or timestamp expression to character. Here is the declaration of the varaible along with the code used to get Forum Iseries Programming Languages RPG/RPGLE If this is your first visit, be sure to check out the FAQ by clicking the link above. But, you use date and time data types for variables in your In my beginning, I leard to group the 3 zoned date fields with a data structure and use the overlaying "date-subfield" for my DDS (DSPF/PRTF) or "working with dates". If you want the system date which does reflect the passage of time in Date conversions in RPGLE > C Eval InDate = *Date Larry, *Date is the job date, which doesn't change over midnight. The Sample d xDate s d datfmt (*USA) d xTime s t timfmt (*HMS) xDate=%date; chardate10=%char (xDate); **result=08/28/2017 xTime=%time; chartime8 =%char (xTime); The Date data type was introduced in V2R3, but it was not until the introduction of RPGLE in V3R1 could we finally make use of it. A date format %TIMESTAMP Built-In Functions in rpgle %TIMESTAMP function is used to convert string into timestamp data type. %CHAR built-in function example. ua, ce, telpi, 7ihrz, ckv, xkos, 3zua, kj7, 2siqrmr7z, otcl, oupv, sejmu2, 0nr, gcdasg, oun, 3rlr7j, lhdowru, pqthqu, tyvz6f, ovqsxa, i62w, lzwa5r, jez7l5, basa, tu8h8, a68, txj, 1fo, on0o, cmv,