Time2str

sql

FUNCTION Time2str(IN tm TIME, IN prez SMALLINT) RETURNS CHAR(n);

Parameters

tm value to be converted
prez conversion type

Description

The Time2str function converts the value specified in the first parameter into character string. The prez parameter may have the following values:

Value Description
0 time notation will only contain hours and minutes;
1 time notation will contain hours, minutes and seconds;
2 time notation will contain hours, minutes, seconds and thousandths of seconds;
3 time notation will have the Windows format;
99 time notation will correspond with the 602SQL syntax of a literal in SQL; the notation will contain hours, minutes, seconds and thousandths of seconds.

Function value

This function returns the text notation of tm time.

Example:

SET str = Time2str(CURRENT_TIME, 1);

See