Ken Hill <ken@scottshill.com> writes:
> On Fri, 2006-02-10 at 07:38 +0100, A. Kretschmer wrote:
>> You can't define the format in the db, but you can define the
>> output-format with to_char(date, 'DD-MM-YYYY');
> You could also try using the data_part() function:
Setting the DateStyle parameter may also be of use, particularly on the
input side.
regards, tom lane