function

PostgreSQL Tutorial: CURRENT_TIME Function

Summary: The PostgreSQL CURRENT_TIME function returns the current time with time zone.

Continue reading

PostgreSQL Tutorial: EXTRACT Function

Summary: The PostgreSQL EXTRACT() function retrieves a field such as a year, month, and day from a date/time value.

Continue reading

PostgreSQL Tutorial: LEFT Function: Get First N Characters in a String

Summary: The PostgreSQL LEFT() function returns the first n characters in the string.

Continue reading

PostgreSQL Tutorial: LOCALTIME Function

Summary: The PostgreSQL LOCALTIME function returns the current time at which the current transaction starts.

Continue reading

PostgreSQL Tutorial: LOCALTIMESTAMP Function

Summary: The PostgreSQL LOCALTIMESTAMP function returns the current date and time at which the current transaction starts.

Continue reading

PostgreSQL Tutorial: LPAD Function

Summary: The PostgreSQL LPAD() function pads a string on the left to a specified length with a sequence of characters.

Continue reading

PostgreSQL Tutorial: MD5 Function

Summary: The PostgreSQL MD5() function calculates the MD5 hash of a string and returns the result in hexadecimal.

Continue reading

PostgreSQL Tutorial: RIGHT Function: Get Last N characters in a String

Summary: The PostgreSQL RIGHT() function returns the last n characters in a string.

Continue reading

PostgreSQL Tutorial: SPLIT_PART Function

Summary: The PostgreSQL SPLIT_PART() function splits a string on a specified delimiter and returns the nth substring.

Continue reading

PostgreSQL Tutorial: TO_CHAR Function

Summary: The PostgreSQL TO_CHAR() function converts a timestamp, an interval, an integer, a double precision, or a numeric value to a string.

Continue reading