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