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.
PostgreSQL Tutorial: LPAD Function
Summary: The PostgreSQL LPAD() function pads a string on the left to a specified length with a sequence of characters.
PostgreSQL Tutorial: MD5 Function
Summary: The PostgreSQL MD5() function calculates the MD5 hash of a string and returns the result in hexadecimal.
PostgreSQL Tutorial: RIGHT Function: Get Last N characters in a String
Summary: The PostgreSQL RIGHT() function returns the last n characters in a string.
PostgreSQL Tutorial: SPLIT_PART Function
Summary: The PostgreSQL SPLIT_PART() function splits a string on a specified delimiter and returns the nth substring.
PostgreSQL Tutorial: TO_DATE Function: Convert String to Date
Summary: This tutorial introduces you to the PostgreSQL TO_DATE() function that helps you convert a string to a date.
PostgreSQL Tutorial: TO_NUMBER Function
Summary: The PostgreSQL TO_NUMBER() function converts a character string to a numeric value.