SQL602_build

sql

FUNCTION SQL602_build RETURNS INT;

Description

The SQL602_build function returns the 602SQL build number. The upper word specifies the major build number (year), the lower word specifies the minor build number (month and day).

Function value

This function returns the 602SQL build number.

Example (SQL):

FUNCTION `srv_version`() RETURNS CHAR(10);
/*****************************************************/
BEGIN
  DECLARE i INT;
  DECLARE vers CHAR(10);
  SET i = SQL602_version;
  SET vers = Int2str(i div 65536)||'.'||Int2str(i mod 65536);
  SET i = SQL602_build;
  SET vers = vers||'.'||Int2str(i div 65536)||'.'||Int2str(i mod 65536);
  RETURN vers;
END

See