ifx_dttofmtasc()

Converts a datetime value to a character string, specifying the format.

Syntax

mint ifx_dttofmtasc(dtime_t *d, char *output, mint len, char *fmt, char c);

d is a pointer to the initialized datetime variable to convert.
output is a pointer to the buffer that receives the string for the value in d.
len is the length of the output buffer.
fmt points the a formatting string.
c is a character that determines which century to apply to the year portion of the date.

Returns

Table 1. Return codes
Code	Description
0	The conversion was successful.
<0	The conversion failed.

Usage

The fmt parameter defines the formatting mask. The default datetime format conforms to the standard ANSI SQL format: %Y-%m-%d %H:%M:%S

The function allows you to specify the century setting for two-digit dates. The c parameter must be one of century characters, which determines which century to apply to the year portion of the date.