Re: date

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