PostgreSQL - how to convert string to date with universal format

Question

Is there universal way to convert a string to date in PostgreSQL if you don’t know the string format in advance?

For example: the string date may be in yyyy-mm-dd or dd-mm-yyyy format or something else.

Thanks!

"if you don’t know the string format in advance" no. The only way is to test various formats and see which one succeeds. — user330315
– user330315, Commented Apr 22, 2020 at 8:06

Paras Bhattrai · Accepted Answer · 2020-04-22 07:58:09Z

1

Try typecasting the string to timestamp and then date. Something like:

select '2010-01-01 12:00:00'::timestamp::date

answered Apr 22, 2020 at 7:58

Paras Bhattrai

6376 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

pifor · Accepted Answer · 2020-04-22 08:04:07Z

0

There is no universal parameter to handle any date format. You have the DateStyle parameter and and the date/time interpretation rules.

answered Apr 22, 2020 at 8:04

pifor

7,9722 gold badges11 silver badges18 bronze badges