PostgreSQL Tutorial: TRANSLATE Function
Summary: The PostgreSQL TRANSLATE() function performs several single-character, one-to-one translation in one operation.
PostgreSQL Tutorial: AGE Function: Calculate Ages
Summary: In this tutorial, you will learn how to use the PostgreSQL AGE() function to calculate ages.
PostgreSQL Tutorial: ASCII Function: Get ASCII code or Unicode Code Point of a Character
Summary: The PostgreSQL ASCII() function returns an ASCII code value of a character. In the case of UTF-8, the ASCII() function returns the Unicode code point of the character.
PostgreSQL Tutorial: CHR Function: Get Character Based on ASCII or Unicode Code Point
Summary: The PostgreSQL CHR() function converts an integer ASCII code to a character or a Unicode code point to a UTF8 character.
PostgreSQL Tutorial: CURRENT_DATE Function
Summary: The PostgreSQL CURRENT_DATE function returns the current date.
PostgreSQL Tutorial: CURRENT_TIME Function
Summary: The PostgreSQL CURRENT_TIME function returns the current time with time zone.
PostgreSQL Tutorial: EXTRACT Function
Summary: The PostgreSQL EXTRACT() function retrieves a field such as a year, month, and day from a date/time value.
PostgreSQL Tutorial: LEFT Function: Get First N Characters in a String
Summary: The PostgreSQL LEFT() function returns the first n characters in the string.
PostgreSQL Tutorial: LOCALTIME Function
Summary: The PostgreSQL LOCALTIME function returns the current time at which the current transaction starts.
PostgreSQL Tutorial: LOCALTIMESTAMP Function
Summary: The PostgreSQL LOCALTIMESTAMP function returns the current date and time at which the current transaction starts.