New functions

Table 3-11 describes the functions added for Adaptive Server version 12.5.0.3.

**Table 3-11: New functions**
Global variable	Definition
year	Returns an integer that represents the year in the datepart of a specified date.
month	Returns an integer that represents the month in the datepart of a specified date.
day	Returns an integer that represents the day in the datepart of a specified date.
str_replace	Replaces any instances of the second string expression (string_expression2) that occur within the first string expression (string_expression1) with a third expression (string_expression3.
square	Returns the square of a specified value expressed as a float.
left	Returns a specified number of characters on the left end of a character string.
len	Returns the number of characters, not the number of bytes, of a specified string expression, excluding trailing blanks.
newid	Generates human-readable, globally unique IDs (GUIDs) in two different formats, based on arguments you provide. The length of the human-readable format of the GUID value is either 32 bytes (with no dashes) or 36 bytes (with dashes).
tempdb_id	Reports the temporary database to which a given session is assigned.
next_identity	Retrieves the next identity value that is available for the next insert.
identity_burn_max	Tracks the identity burn max value for a given table.