How to convert US date format to European date format ?

From: Condor <condor(at)stz-bg(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to convert US date format to European date format ?
Date: 2013-04-10 13:03:45
Message-ID: 0acc2d7fa93c1423ba0bca6ab02b3001@stz-bg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello ppl,

I have a database where the previous owner use US date format in date
fields:

2009-02-18

Is there a way how to convert the fields in European format 18-02-2009.
I mean existing date in records. What's will be happened if I change
format
in postgresql.conf ?

Cheers,
Hristo S.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2013-04-10 13:15:21 Re: How to convert US date format to European date format ?
Previous Message Thomas Kellerer 2013-04-10 12:43:48 Re: how to find which tables required indexes in postgresql