timestamp2str

sql

FUNCTION timestamp2str(IN dtm TIMESTAMP, IN prez SMALLINT) RETURNS CHAR(n);

Parameters

dtm value to be converted
prez conversion type

Since version:

6.0

Description

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

Value Description
4 27.12. 12:45:56
5 27.12.1998 12:45:56
10 27.12.
11 27.12.1998
16 27.12. 12:45
17 27.12.1998 12:45
99 notation will correspond with the 602SQL syntax of a literal in SQL; 27.12.1998 12:45:56

Function value

This function returns the text notation of dtm parameter.

Viz