Re: Custom DateStyle - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Custom DateStyle
Date
Msg-id 20050720154047.GA28775@wolff.to
Whole thread Raw
In response to Custom DateStyle  (Amir Tahvildaran <amir@mathforum.org>)
List pgsql-general
On Tue, Jul 19, 2005 at 11:51:55 -0400,
  Amir Tahvildaran <amir@mathforum.org> wrote:
> Is it possible to add a custom datestyle?
>
> I am migrating from sybase to postgres and the datetime/timestamp
> formats are different, some of the existing code depends on that
> format.  I thought the easiest way would be to use a custom datestyle,
> but I couldn't find out how to add one (if thats possible).  Does anyone
> have any better ideas?

You can use to_char to convert dates to strings in custom formats.
That may do what you want.

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: Quotation marks in queries
Next
From: Tony Caduto
Date:
Subject: Re: Quotation marks in queries