How to change string in DMY format to date in PostgreSQL data source in Bold BI^®?

Converting string in DMY format to Date in PostgreSQL

In the PostgreSQL data source, you may need to convert a date string in different formats to date column. The default conversion only allows for mdy format. This article will guide you on how to convert a date string from the 'dd-mm-yyyy' format to date values.

Steps to Convert Date String Format:

1. Identify the column containing the date string in your table. The datatype of the column must be of the string type.

2. Use the `to_date` function to convert the date string format.

Here's the expression to convert the string to date:

to_date([your column name], '<date-format>')

The first argument is the string that you want to convert to a date. Replace `your column name` with the actual column name containing the date string.

Example:

Consider a column named `date` containing date strings in the 'dd-mm-yyyy' format. 

to_date([date], 'dd-mm-yyyy')

This expression will return the date values for the column.

Related Links:

• Configuring Expression Columns
• PostgreSQL Date/Time Functions and Operators.
• PostgreSQL Date/Time Types.
• PostgreSQL Function formatting