Last 3 digits of ISO 8601 week-numbering year ISO 8601 week-numbering year (4 or more digits) The following table illustrates the template patterns for formatting date values: Pattern In this example, the string 20170103 is converted into a date based on the input format YYYYMMDD.Īs the result, the function returns January 3rd 2017. See the following example: SELECT TO_DATE( '20170103', 'YYYYMMDD') Code language: SQL (Structured Query Language) ( sql )Ĭode language: SQL (Structured Query Language) ( sql ) The TO_DATE() function returns a date value. The first argument is the string that you want to convert to a date. The TO_DATE() function accepts two string arguments.
The following illustrates the syntax of the TO_DATE() function: TO_DATE(text,format) Code language: SQL (Structured Query Language) ( sql ) The TO_DATE() function converts a string literal to a date value. Introduction to the PostgreSQL TO_DATE function Summary: this tutorial introduces you to the PostgreSQL TO_DATE() function that helps you convert a string to a date.
