9951 explained code solutions for 126 technologies

postgresqlHow do I use the PostgreSQL to_char function?

The PostgreSQL to_char function is used to convert a timestamp or number into a string. The syntax of the to_char function is as follows:

to_char(value, format)

Where value is the timestamp or number to be converted and format is the format to use for the conversion.

For example, to convert a timestamp to a string with the format of 'DD-MON-YYYY' you would use the following:

SELECT to_char(current_timestamp, 'DD-MON-YYYY');

Which would output something like:


The format argument can contain a wide variety of elements, including:

  • YYYY: 4-digit year
  • MM: 2-digit month
  • DD: 2-digit day
  • HH24: 24-hour format
  • MI: Minute
  • SS: Second

For a full list of available elements, see the PostgreSQL documentation.

The to_char function is very useful when working with timestamps and numbers, allowing them to be easily converted into strings for display or other purposes.

Edit this code on GitHub