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.
PostgreSQL Tutorial: TO_TIMESTAMP Function
Summary: In this tutorial, you will learn how to use the PostgreSQL TO_TIMESTAMP() function to convert a string to a timestamp based on a specified format.
PostgreSQL Tutorial: CURRENT_TIMESTAMP Function
Summary: The PostgreSQL CURRENT_TIMESTAMP() function returns the current date and time with time zone, which is the time when the transaction starts.
PostgreSQL Tutorial: DATE_PART Function
Summary: In this tutorial, we will introduce you to the PostgreSQL DATE_PART() function that allows you to retrieve subfields e.g., year, month, week from a date or time value.
PostgreSQL Tutorial: DATE_TRUNC Function
Summary: This tutorial shows you how to use the PostgreSQL date_trunc() function to truncate a timestamp or interval to a specified level of precision.
PostgreSQL Tutorial: FORMAT Function
Summary: PostgreSQL FORMAT() function formats arguments based on a format string.
PostgreSQL Tutorial: NOW Function
Summary: This tutorial shows you how to use the PostgreSQL NOW() function to get the date and time with time zone.
PostgreSQL Tutorial: REGEXP_MATCHES Function
Summary: The PostgreSQL REGEXP_MATCHES() function matches a regular expression against a string and returns matched substrings.
PostgreSQL Tutorial: REGEXP_REPLACE Function
Summary: In this tutorial, you will learn how to use the PostgreSQL REGEXP_REPLACE() function to replace strings that match a regular expression.