Re: date

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ken(at)scottshill(dot)com
Cc: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: date
Date: 2006-02-10 16:59:48
Message-ID: 21046.1139590788@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Ken Hill <ken(at)scottshill(dot)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

In response to

  • Re: date at 2006-02-10 16:17:00 from Ken Hill

Browse pgsql-sql by date

  From Date Subject
Next Message Ken Hill 2006-02-10 17:52:47 Deleting rows in a file based on condition
Previous Message Ken Hill 2006-02-10 16:22:03 Re: query