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.
Day: June 24, 2018
Sql TRANSLATE function
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