Date2str

sql

FUNCTION Date2str(IN dt DATE, IN prez SMALLINT) RETURNS CHAR();

Parameters

dt value to be converted
prez conversion type

Description

The Date2str function converts the values specified in the first parameter to a character string.

The value of the prez parameter is used as follows:

Value Description
0 the date notation will contain only the date and month as digits, without the year;
1 the date notation will contain the date and month as digits and the year;
2 the date notation will contain only the date and month as words, without the year;
3 the date notation will contain the date and month as words and the year;
4 the date notation will use the Windows long format
5 the date notation will use the Windows short forma
99 the date notation will correspond with the 602SQL syntax of literal in SQL; it will contain the date and month as digits and the year.

Function value

This function returns the text notation of the dt date.

See