Day: June 24, 2018

Sql TRANSLATE function

The Sql TRANSLATE() function replaces a sequence of characters in a string with another sequence of characters. The function replaces a single character at a time. Example: Select TRANSLATE(‘This@is@an@example.’,  ‘ ‘,  ‘@’ ) From Sysibm/Sysdummy1 Result:    This is an example.  

Sql Varchar_Format Function

The VARCHAR_FORMAT function returns a string representation of a timestamp that has been formatted according to a specified character template Example : Select Varchar_Format(Current_Date, ‘YYYYMM’) From Sysibm/Sysdummy1 This query returns 201806